Overclock.net banner

201 - 211 of 211 Posts

·
>^o.o^<___/
Joined
·
142 Posts
Six more data points from two PCs:
ran the case, found that excel was 2016.32 despite both windows and license being 64bit. reinstalled office to 64bit, ran again, downloaded 1909 excel update with an interesting message from MS and reran.

ran on an ultra-low-voltage intel laptop with office2019-64bit.
also checked the effects of memory speed, and tried to level the field (board only goes as low as 2.7GHz).

Ryzen1700-3.9GHz-8core-16thread-16GB-DDR4-3200-Excel2016-32bit-179sec - ran only 1 thread
Ryzen1700-3.9GHz-8core-16thread-16GB-DDR4-3200-Excel2016-64bit-87sec - ran only 1 thread
Ryzen1700-3.9GHz-8core-16thread-16GB-DDR4-3200-Excel2016-1909-64bit-68sec - ran only 1 thread
intel i5-3439Y-2.0GHz-2core-4thread-4GB-DDR3-1600-Excel2019-1908-64bit-202sec - ran on 2! threads
Ryzen1700-3.9GHz-8core-16thread-16GB-DDR4-2133-Excel2016-1909-64bit-76sec - ran only 1 thread
Ryzen1700-2.7GHz-8core-16thread-16GB-DDR4-1600-Excel2016-1909-64bit-90sec - ran only 1 thread

Multithreaded and EnableMultithreaded boxes checked in Options-Advanced
 

Attachments

·
Registered
Joined
·
1 Posts
Stock 3950x
May i know which version/build of excel are u using? and ram? thxthx

------------
Update: From the previous posts I guess u are using excel 2019 64 bits, may i ask whether u can try the same test using 3950x but using single thread? I am very curious on how 3950x perform in spreadsheet that has a highly sequential calculation chain which has no benefit in using multi core..........appreciate that!

And do u think the performance will go sub 40s if PBO is enabled?

-------
For my stone age PC (Q9450) + Excel 2016 64 bits
If multi core/threading is on: 287s
If multi core/threading is off: 272s

Weird.
 

Attachments

·
Registered
Joined
·
1 Posts
i7-8650U on Office 365

CPU: i7-8650U
#CPU cores: 4
CPU clock speed: 1.9GHz
Total system memory: 16GB
Excel ver: Office 365
Time to sort (in seconds): 72.2 seconds
 

·
Registered
Joined
·
1 Posts
Hi, my speed:

----
CPU: Ryzen 5 2400G
#Cores: 4 (8 threads)
CPU clock speed: 3.13 GHz
Total system memory: 16 MB
memory speed: 2934 MHz (according to AIDA64 v5.70.3800)
Excel version: Excel for Office 365 (I think = 2016)
32/64 bit: 32 bit
time to sort (in seconds): 237
----

Note: I do not overclock. When running the bench, Excel drives all 8 threads to max. 33%


Keosoft
 

·
Registered
Joined
·
4 Posts
CPU: 3770K
#Cores: 4
CPU clock speed: 4.5 Ghz
Total system memory: 24 GB
Memory speed: DDR3-2200-10-12-12-30
Excel version: 2010
32/64 bit: 32 bit
Time to sort (in seconds): 155.68 s

CPU load stayed almost stable at 20 % during the benchmark.
I tried it again. Same hardware system but updated office and 50% faster:

Excel version: 2016
32/64 bit: 64 bit
Time to sort (in seconds): 81.73 s
 

·
Overclock.net user
Joined
·
447 Posts
Hello,
just to share my results:

CPU: Ryzen 7 1700
#Cores: 8 (16 threads)
CPU clock speed: 4.065 GHz
Total system memory: 16 MB
memory speed: 3500 MHz (14-13-13-13-22-36-252 1t)
Excel version: Excel for Office Professional Plus 2019
32/64 bit: 64 bit
time to sort (in seconds): 67.7
 

·
Registered
Joined
·
3,147 Posts
Hmmm... kinda want to try this, but I use Libre office. Not rusre how usefull my numbers will be for you.
 

·
OCN is bad civilization
Joined
·
3,529 Posts
I ran it in libre office on Mid 2012 Macbook Air. Result was 62 seconds. Comparing it to the results in OP, I doubt very seriously that it is correct lmao.
 

·
Registered
Joined
·
5 Posts
I updated my RAM on my Zen 2, see Entry 7

CPU: 3800X Zen 2 / 9900K
Clock speed stock: 3.9 GHZ, 4.475 GHZ Boost / 3.6 GHz, 4.7 GHz Turbo
Memory: 2x8GB CL14 3200MHz / 2x8GB CL19 3600MHz
Office 365, Excel, Version 1902: 64 bit (same)
Time: 47.39 secs / 50.79 secs


What really baffles me, and I think there must've been an update to Excel is that:
1. 9900K tested on 4 May, 50.71 (I cant recall the Excel version)
2. 9900K tested on 30 July, 50.79
3. 2700X tested on 29 Apr, 95+ (I cant recall the Excel version)
4. 3800X tested on 29 July, 47.39
5. 3800X tested on July 29, 47.39s (and was usually within this range) - using a Gigabyte X470 Aorus Gaming 7 WiFi
6. 3800X tested on 3 Sep, 50.6s - using a Gigabyte X570 Aorus Master (updated BIOS)
7. 3800X tested on 16 Jul, 44.83 - using a Gigabyte X570 Aorus Master (updated BIOS), 4x8GB CL16 RAM
 

Attachments

·
sudo apt install sl
Joined
·
7,298 Posts
CPU: 9900k
#Cores: 8
CPU clock speed: 5.2Ghz
Total system memory: 32GB
memory speed: 3200Mhz CL 15
LibreOffice Calc Version: 6.4.1.2
32/64 bit: 64 bit
time to sort (in seconds): 9
 

Attachments

201 - 211 of 211 Posts
Top