Excel Benchmark - Overclock.net - An Overclocking Community

Forum Jump: 

Excel Benchmark

Reply
 
Thread Tools
post #1 of 201 (permalink) Old 11-15-2017, 06:58 AM - Thread Starter
Linux Lobbyist
 
ir88ed's Avatar
 
Join Date: Jan 2014
Posts: 256
Rep: 18 (Unique: 18)
Hey benchmarkers! For my job I do a lot of my work with pretty huge Excel spreadsheets, and I have seen the Ryzen vids appearing to show a performance edge for the 1700x vs. the 7700k (my current workstation PC). I would like to tap the hive mind here to see if this holds up in a real-world experiment.

In my spreadsheets I am loath to convert my formulas into values, as I can't go back later to verify that the calculations were performed correctly. But this creates huge issues with sorting, as sorting with formulas can take a really long time. I have put together a modestly complex spreadsheet of random data and formulas. I would be curious to see how the intel chips with faster cores (OC is fine) stack up against the AMD chips with more cores (again, OC is fine) doing a simple sort on one of the columns. Excel can take advantage of multiple cores, so it should be an interesting battle between the intel and amd chips.

If you are interested, here is a link to my spreadsheet on googledocs, which now includes a benchmark button and timer courtesy of huzzug:

https://drive.google.com/open?id=1tVTAdP6WczJvlEAJNGhZXX87UJXH6vAV

Original non-timer sheet is here:
https://drive.google.com/open?id=1UTgkRg4yfCcoSZDxhIUD1Q99e7-26Tqx

You will need to download the spreadsheet and run the benchmark in your local MS Excel (not in google sheets). Just see how long it takes your PC to complete the sort. 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. Just close and open again if you want to do a second run. Please do no more than two runs unless you reboot. For some reason the sort times seem drop significantly the third time the bencmark is run. Don't blame me, I didn't make Excel.

It would be helpful to have the following information:
CPU:
#Cores:
CPU clock speed:
Total system memory:
memory speed:
Excel version:
32/64 bit:
time to sort (in seconds):

Here is what I have compiled so far:

i7 8086K @5.0Ghz
2x EVGA GTX1080ti
XSPC Waterblocks
1600W EVGA T2 PSU
Corsair Graphite T760 case
3x Samsung 4K monitors (U28D590D) @67fps
ir88ed is offline  
Sponsored Links
Advertisement
 
post #2 of 201 (permalink) Old 11-15-2017, 08:45 AM
9 Cans of Ravioli
 
The Pook's Avatar
 
Join Date: May 2006
Posts: 16,749
Rep: 1099 (Unique: 636)
Quote:
CPU: 6400 Skylake
#CPU cores: 4
CPU clock speed: 2.7GHz
Total system memory: 8GB
Excel ver: 2016
Time to sort (in seconds): 131 seconds

Intel i9 9900K Coffee Lake @ X8 5309mhz (+47.5%)
AMD FX-8320 Vishera @ X4 5022mhz (+43.5%)
Intel i5 4690K Haswell @ X4 5013mhz (+43.2%)
AMD X4 960T Zosma @ X6 4870mhz (+62.3%)
Intel i7 6700 Skylake @ X4 4709mhz (+38.5%)
Intel i5 6400 Skylake @ X4 4588mhz (+69.9%)
2 OP pls nerf
(24 items)
NUC U
(10 items)
CPU
i9 9900K
Motherboard
AsRock Z390 Taichi
GPU
MSI GTX 1080 Ti
RAM
G.Skill DDR4 4133 32GB
Hard Drive
Mushkin Pilot NVMe 1TB
Hard Drive
HP EX950 NVMe 2TB
Hard Drive
Samsung 860 Evo 1TB
Hard Drive
Sandisk Ultra II 480GB SSD
Hard Drive
Toshiba X300 5TB
Hard Drive
Western Digital EZRZ 3TB
Power Supply
Seasonic Focus Plus Gold 750w
Cooling
Corsair H115i Pro
Case
Fractal Design Meshify S2
Operating System
Windows 10 Education x64
Monitor
Acer XF270HU
Monitor
Dell E2311H
Keyboard
CoolerMaster MasterKeys Pro S
Mouse
Logitech G502
Audio
SMSL SA50 + FiiO E10K
Audio
Micca RB42
Audio
Polk Audio PSW111
Audio
Philips Fidelio X2
Audio
Philips SHP9500S
Audio
Audio Technica ATH-M50X
CPU
i3 8109U
Motherboard
Intel NUC8i3BEH
GPU
Iris Plus 655
RAM
Kingston 8GB DDR4 2400
Hard Drive
Dierka K1 120GB
Hard Drive
ADATA SU800 128GB M.2
Operating System
Windows 10 Professional
Operating System
MX Linux
Keyboard
Rii RKM709 Wireless
Mouse
Logitech M510
CPU
i7 860
Motherboard
Advantech AIMB 280 ITX
GPU
EVGA GTX 950 2GB
RAM
Kingston 2GB DDR3 1333
Hard Drive
Seagate Momentus 2.5" 500GB
Hard Drive
Western Digital Blue 2.5" 320GB
Power Supply
Silverstone SFX-L Gold 500w
Cooling
Arctic Alpine 11 GT 2
Case
Silverstone Milo Z ML07B
Operating System
Windows XP x86 SP3
Keyboard
Velocifire TKL01 Outemu Browns
Mouse
Logitech M512
▲ hide details ▲


The Pook is offline  
post #3 of 201 (permalink) Old 11-15-2017, 09:02 AM - Thread Starter
Linux Lobbyist
 
ir88ed's Avatar
 
Join Date: Jan 2014
Posts: 256
Rep: 18 (Unique: 18)
Nice! Any chance you will do it again with your 4.58GHz OC, or whatever will stay stable for the sort? I will make some graphs if I get enough data, but I am guessing your 6400 is pretty close to the 7700K in my workstation at the same frequency.

i7 8086K @5.0Ghz
2x EVGA GTX1080ti
XSPC Waterblocks
1600W EVGA T2 PSU
Corsair Graphite T760 case
3x Samsung 4K monitors (U28D590D) @67fps
ir88ed is offline  
Sponsored Links
Advertisement
 
post #4 of 201 (permalink) Old 11-15-2017, 09:10 AM
9 Cans of Ravioli
 
The Pook's Avatar
 
Join Date: May 2006
Posts: 16,749
Rep: 1099 (Unique: 636)
I bought a 7700K, had to flash the BIOS off the modded one, killed the 7700K, and unable to back flash the BIOS now. Stuck at stock. frown.gif

Intel i9 9900K Coffee Lake @ X8 5309mhz (+47.5%)
AMD FX-8320 Vishera @ X4 5022mhz (+43.5%)
Intel i5 4690K Haswell @ X4 5013mhz (+43.2%)
AMD X4 960T Zosma @ X6 4870mhz (+62.3%)
Intel i7 6700 Skylake @ X4 4709mhz (+38.5%)
Intel i5 6400 Skylake @ X4 4588mhz (+69.9%)
2 OP pls nerf
(24 items)
NUC U
(10 items)
CPU
i9 9900K
Motherboard
AsRock Z390 Taichi
GPU
MSI GTX 1080 Ti
RAM
G.Skill DDR4 4133 32GB
Hard Drive
Mushkin Pilot NVMe 1TB
Hard Drive
HP EX950 NVMe 2TB
Hard Drive
Samsung 860 Evo 1TB
Hard Drive
Sandisk Ultra II 480GB SSD
Hard Drive
Toshiba X300 5TB
Hard Drive
Western Digital EZRZ 3TB
Power Supply
Seasonic Focus Plus Gold 750w
Cooling
Corsair H115i Pro
Case
Fractal Design Meshify S2
Operating System
Windows 10 Education x64
Monitor
Acer XF270HU
Monitor
Dell E2311H
Keyboard
CoolerMaster MasterKeys Pro S
Mouse
Logitech G502
Audio
SMSL SA50 + FiiO E10K
Audio
Micca RB42
Audio
Polk Audio PSW111
Audio
Philips Fidelio X2
Audio
Philips SHP9500S
Audio
Audio Technica ATH-M50X
CPU
i3 8109U
Motherboard
Intel NUC8i3BEH
GPU
Iris Plus 655
RAM
Kingston 8GB DDR4 2400
Hard Drive
Dierka K1 120GB
Hard Drive
ADATA SU800 128GB M.2
Operating System
Windows 10 Professional
Operating System
MX Linux
Keyboard
Rii RKM709 Wireless
Mouse
Logitech M510
CPU
i7 860
Motherboard
Advantech AIMB 280 ITX
GPU
EVGA GTX 950 2GB
RAM
Kingston 2GB DDR3 1333
Hard Drive
Seagate Momentus 2.5" 500GB
Hard Drive
Western Digital Blue 2.5" 320GB
Power Supply
Silverstone SFX-L Gold 500w
Cooling
Arctic Alpine 11 GT 2
Case
Silverstone Milo Z ML07B
Operating System
Windows XP x86 SP3
Keyboard
Velocifire TKL01 Outemu Browns
Mouse
Logitech M512
▲ hide details ▲


The Pook is offline  
post #5 of 201 (permalink) Old 11-15-2017, 09:14 AM - Thread Starter
Linux Lobbyist
 
ir88ed's Avatar
 
Join Date: Jan 2014
Posts: 256
Rep: 18 (Unique: 18)
Quote:
Originally Posted by The Pook View Post

I bought a 7700K, had to flash the BIOS off the modded one, killed the 7700K, and unable to back flash the BIOS now. Stuck at stock. frown.gif
That sucks.

i7 8086K @5.0Ghz
2x EVGA GTX1080ti
XSPC Waterblocks
1600W EVGA T2 PSU
Corsair Graphite T760 case
3x Samsung 4K monitors (U28D590D) @67fps
ir88ed is offline  
post #6 of 201 (permalink) Old 11-15-2017, 12:12 PM
External VRM FTW
 
mllrkllr88's Avatar
 
Join Date: Apr 2008
Location: Portland, OR
Posts: 2,318
Nice man!! This is interesting for sure biggrin.gif

Its difficult to tell and I am guessing there is some error in the way you are timing it, but it appears that core count is effecting the bench result. It would be interesting to see if the 7700K produced the same result with 2/2 vs 4/8. Do you have the ability to turn off HT and reduce the core count on your 7700K computer? I might join in the fun when I get some free time, I can run i9 7940x (14c) and see how core scaling holds up.

Ok, its a bit of a pipe dream here, but it would be cool to see this worked into an actual benchmark program haha. With a start button and auto timer function, but requiring MS Office installed is a huge drawback for benchers.

I cant want to see more thumb.gif

24/7 BENCH
(9 items)
CPU
[LGA115x] 8700k, 7700K, 7350k, G3258
CPU
[LGA2066] 7940X, 7740X
Motherboard
[OCF FTW] X299 OCF, Z170M OCF, Z97 OCF
GPU
E-Power, G-Power, H-Power, A-Power
RAM
B-DIE, HYKO, PSC, MFR
Power Supply
Seasonic Prime Platinum 1200W
Cooling
Kingpin Cooling: Venom & T-REX
Cooling
2x360 RAD Custom Loop
Case
Dimastech Easy V3.0
▲ hide details ▲


mllrkllr88 is offline  
post #7 of 201 (permalink) Old 11-15-2017, 12:25 PM
Filthy Casual
 
bajer29's Avatar
 
Join Date: Nov 2009
Location: Round on the End and High in the Middle
Posts: 2,936
Rep: 107 (Unique: 92)
CPU: i5 6500
#CPU cores: 4
CPU clock speed: 3.6GHz
Total system memory: 8GB
Excel ver: 2016
Time to sort (in seconds): 154 seconds

Xeno Storm V 1.2
(17 items)
CPU
i7 4790K (delidded)
Motherboard
GIGABYTE|GA-Z87X-D3H
GPU
EVGA 1080TI FTW3
RAM
4x4GB GSKILL @ 2133MHz
Hard Drive
WD 1002FAEX
Hard Drive
KINGSTON V300 120GB
Hard Drive
SanDisk Ultra Plus 128GB
Hard Drive
Samsung 850 EVO 500GB
Hard Drive
WD Green WD5000AADS
Power Supply
Corsair AX850
Cooling
Cryorig R1 Ultimate
Case
Phanteks Enthoo Pro M SE
Operating System
Windows 10 Enterprise
Monitor
Acer XB270HU Predator
Keyboard
E-Element Z-88 RGB
Mouse
Corsair M65
Audio
Logitech X230 2.1
▲ hide details ▲


bajer29 is offline  
post #8 of 201 (permalink) Old 11-15-2017, 01:09 PM
New to Overclock.net
 
Join Date: Dec 2008
Posts: 864
Rep: 50 (Unique: 48)
CPU: Ryzen R5 1600
#CPU cores: 6
CPU clock speed: 3.90GHz
Total system memory: 16GB
Excel ver: 2016
Time to sort (in seconds): 106 seconds

Ryzen R5 1600 @ 3.90GHz (1.35V - 1.337V SVI2 TFN) | NH-D14 | Asus Prime X370 Pro (0902) | GSkill 16GB F4-2800C15-8GVR @ 2933MHz (16-16-16-36-1T) | GTX 970 @ 1507-1978/ R9 390 @ 1140-1600 | 2 SSDs and 2 Mechanical drives | Rosewill Capstone 750M | NZXT Source 220 | Windows 10 Pro x64
daffy.duck is offline  
post #9 of 201 (permalink) Old 11-15-2017, 01:25 PM - Thread Starter
Linux Lobbyist
 
ir88ed's Avatar
 
Join Date: Jan 2014
Posts: 256
Rep: 18 (Unique: 18)
Quote:
Originally Posted by daffy.duck View Post

CPU: Ryzen R5 1600
#CPU cores: 6
CPU clock speed: 3.90GHz
Total system memory: 16GB
Excel ver: 2016
Time to sort (in seconds): 106 seconds

Here come the Ryzens. I suspected that core count was going to be a big factor and the R5 1600 does a good job of making that point. It is going toe to toe with a 7700K @ 4.5GHz and my 6 core 5930K @ 3.7GHz.

i7 8086K @5.0Ghz
2x EVGA GTX1080ti
XSPC Waterblocks
1600W EVGA T2 PSU
Corsair Graphite T760 case
3x Samsung 4K monitors (U28D590D) @67fps
ir88ed is offline  
post #10 of 201 (permalink) Old 11-15-2017, 07:40 PM - Thread Starter
Linux Lobbyist
 
ir88ed's Avatar
 
Join Date: Jan 2014
Posts: 256
Rep: 18 (Unique: 18)
Quote:
Originally Posted by mllrkllr88 View Post

Its difficult to tell and I am guessing there is some error in the way you are timing it, but it appears that core count is effecting the bench result.
Agreed; timing by hand is error prone and a poor approach.

I have looked at some of the visual basic code in excel in spreadsheets that have process timers (like: http://exceltrader.net/excel-benchmark/ ) but it would take me quite a while to figure out how to adapt this. I will do some looking to see if there isn't a more clear example somewhere.

i7 8086K @5.0Ghz
2x EVGA GTX1080ti
XSPC Waterblocks
1600W EVGA T2 PSU
Corsair Graphite T760 case
3x Samsung 4K monitors (U28D590D) @67fps
ir88ed is offline  
Reply

Quick Reply
Message:
Options

Register Now

In order to be able to post messages on the Overclock.net - An Overclocking Community forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.
User Name:
If you do not want to register, fill this field only and the name will be used as user name for your post.
Password
Please enter a password for your user account. Note that passwords are case-sensitive.
Password:
Confirm Password:
Email Address
Please enter a valid email address for yourself.
Email Address:

Log-in



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page


Forum Jump: 

Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off