New Posts  All Forums:Forum Nav:

Excel Benchmark - Page 7

post #61 of 110
Thread Starter 
Quote:
Originally Posted by AlphaC View Post

Tested Ryzen 7 1700X at stock again.

There's some variance on XFR kicking in and also with antivirus.

Original sheet without timer is roughly 3 min 24 seconds. My original run the other day had 3 min 29 seconds on first run.

Huzzug's variation with a fresh boot obtained 212.46 seconds. I noticed the antivirus icon kick in on the first run. Closing Excel and running again resulted in 199.29 seconds.

I really don't know what to make of it because I definitely obtained 30 seconds the other day.


Hmmm... We have a 1600 Ryzen that did a 106 on the original sheet.
The 30 second run sounds like the results you get when you hit the button a second time and the sheet is already presorted.
1700X should beat a 1600 in clock speed alone, so >200 seconds makes me think something is amiss. I would be expecting a number in the 90's or low 100's.
post #62 of 110
I did a full redownload of the file and rebooted and ran the benchmark straight off the overclock.net site.

I obtained 199.18 seconds.

less than 100 seconds suggests multi-thread kicked in. Their Ryzen 5 was overclocked to 3.9 (which is the XFR speed of R7 1700X).

edit: for all intents and purposes, you should base your conclusions around 200 seconds , since when I manually timed I obtained roughly 3 min 25 seconds or so. We know Ryzen IPC is around Haswell and my Sandy Bridge system was also around 200 seconds when overclocked to 4.6.

edit2: you should adjust OP to note that you cannot run the benchmark more than once without reopening it.
Edited by AlphaC - 11/22/17 at 9:52am
post #63 of 110
Thread Starter 
Quote:
Originally Posted by AlphaC View Post

I did a full redownload of the file and rebooted and ran the benchmark straight off the overclock.net site.

I obtained 199.18 seconds.

less than 100 seconds suggests multi-thread kicked in.
Any chance that "enable multi-threaded" option is not selected? Excel Options -> advanced -> formulas -> enable multi-threaded calculation

I think that is set by default, but grasping at straws here.

Quote:
Originally Posted by AlphaC View Post

you should adjust OP to note that you cannot run the benchmark more than once without reopening it.
Good point. I will make it clearer.
Edited by ir88ed - 11/22/17 at 9:57am
post #64 of 110
I checked, it is not the case. It just had 5-6% CPU usage (1 thread) even though 16 were available.

edit: He's on Windows 10 x 64.
Edited by AlphaC - 11/22/17 at 10:03am
post #65 of 110



CPU: i7 8700k
#CPU cores: 6c/12t
CPU clock speed: 5000 / 4500 Cache
Total system memory: 16GB
RAM Speed: DDR4-4000-17-17-17-2T
Excel ver: 2016 Pro
Time to sort (in seconds): 95.42 seconds

Cheers!
post #66 of 110
Quote:
Originally Posted by ir88ed View Post

Any chance that "enable multi-threaded" option is not selected? Excel Options -> advanced -> formulas -> enable multi-threaded calculation

I will check this out on my test OS too. As it stands right now it looks like most of the scaling is coming from core/cache, none from core count/HT for Excel 2010.
24/7 BENCH
(9 items)
 
  
CPUCPUMotherboardGraphics
[LGA115x] 7700K, 7350k, G3258 [LGA2066] 7940X, 7740X [OCF FTW] X299 OCF, Z170M OCF, Z97 OCF E-Power, G-Power, H-Power...WTB A-Power 
RAMCoolingCoolingPower
B-DIE, HYKO, PSC, MFR Kingpin Venom 6.66 2x360 RAD Custom Loop Seasonic Prime Platinum 1200W 
Case
Dimastech Easy V3.0 
  hide details  
Reply
24/7 BENCH
(9 items)
 
  
CPUCPUMotherboardGraphics
[LGA115x] 7700K, 7350k, G3258 [LGA2066] 7940X, 7740X [OCF FTW] X299 OCF, Z170M OCF, Z97 OCF E-Power, G-Power, H-Power...WTB A-Power 
RAMCoolingCoolingPower
B-DIE, HYKO, PSC, MFR Kingpin Venom 6.66 2x360 RAD Custom Loop Seasonic Prime Platinum 1200W 
Case
Dimastech Easy V3.0 
  hide details  
Reply
post #67 of 110
Quote:
Originally Posted by AlphaC View Post

Tested Ryzen 7 1700X at stock again.

There's some variance on XFR kicking in and also with antivirus.

Original sheet without timer is roughly 3 min 24 seconds. My original run the other day had 3 min 29 seconds on first run.

Huzzug's variation with a fresh boot obtained 212.46 seconds. I noticed the antivirus icon kick in on the first run. Closing Excel and running again resulted in 199.29 seconds.

I really don't know what to make of it because I definitely obtained 30 seconds the other day.
Something must be wrong. My FX-8320 got 218 seconds. There's no way a 1700X is equally as slow. Throttling?
post #68 of 110
Quote:
Originally Posted by NightAntilli View Post

Something must be wrong. My FX-8320 got 218 seconds. There's no way a 1700X is equally as slow. Throttling?

Nope. It is AIDA64 AVX / Prime 95 AVX stable, there's no way it is throttling with only one core used.

The CPU wasn't overclocked in these tests. All that shows is 3.5-3.9GHz (depending on XFR kicking in) is roughly faster than 4.6GHz FX-8320 for these types of workloads.

The biggest difference is I'm running Windows 7 Pro x 64 on a fully loaded system with antivirus, not a clean one. Pausing antivirus (without clean restart) results in a score of around 199 seconds. I'd say 200 seconds is about right , even with antivirus on and 2nd run on the same boot I had ~200 seconds.

edit: ran ExcelTrader benchmark


(http://exceltrader.net/984/benchmark_et-xls-an-excel-benchmark-for-traders/)
top is back when system was clean
Edited by AlphaC - 11/22/17 at 4:30pm
post #69 of 110
Quote:
Originally Posted by ir88ed View Post

Quote:
Originally Posted by AlphaC View Post

Tested Ryzen 7 1700X at stock again.

There's some variance on XFR kicking in and also with antivirus.

Original sheet without timer is roughly 3 min 24 seconds. My original run the other day had 3 min 29 seconds on first run.

Huzzug's variation with a fresh boot obtained 212.46 seconds. I noticed the antivirus icon kick in on the first run. Closing Excel and running again resulted in 199.29 seconds.

I really don't know what to make of it because I definitely obtained 30 seconds the other day.


Hmmm... We have a 1600 Ryzen that did a 106 on the original sheet.
The 30 second run sounds like the results you get when you hit the button a second time and the sheet is already presorted.
1700X should beat a 1600 in clock speed alone, so >200 seconds makes me think something is amiss. I would be expecting a number in the 90's or low 100's.

Like this?
Warning: Spoiler! (Click to show)
Ryzen Shine!
(14 items)
 
  
CPUMotherboardGraphicsRAM
Ryzen 1800X @ 4125mhz 1.432 Volts MSI X370 Titanium   Fury  G.SKILL TridentZ Series 32GB (4 x 8GB) 288-Pin... 
Hard DriveOptical DriveCoolingOS
Samsung 850 pro Hp 1260 I liquid unobtanium Koolance 480mm radiator, 39... Win 7 HP/Winspy 10 64bit 
MonitorKeyboardPowerCase
24" hp @ 1900x1200 Logitech G19 PC power and cooling 910 watt silencer Thermaltake P5 
MouseMouse Pad
Logitech MX 518 fUnc industries 
  hide details  
Reply
Ryzen Shine!
(14 items)
 
  
CPUMotherboardGraphicsRAM
Ryzen 1800X @ 4125mhz 1.432 Volts MSI X370 Titanium   Fury  G.SKILL TridentZ Series 32GB (4 x 8GB) 288-Pin... 
Hard DriveOptical DriveCoolingOS
Samsung 850 pro Hp 1260 I liquid unobtanium Koolance 480mm radiator, 39... Win 7 HP/Winspy 10 64bit 
MonitorKeyboardPowerCase
24" hp @ 1900x1200 Logitech G19 PC power and cooling 910 watt silencer Thermaltake P5 
MouseMouse Pad
Logitech MX 518 fUnc industries 
  hide details  
Reply
post #70 of 110
Thread Starter 
Note that you can only run the benchmark once in the worksheet. Once the sheet is sorted the calc times drop to less than 30 seconds if you re-bench.

Best way is to reboot the system, open the sheet and sort only one time.
New Posts  All Forums:Forum Nav:
  Return Home