Overclock.net - An Overclocking Community

Overclock.net - An Overclocking Community (https://www.overclock.net/forum/)
-   Benchmarking Software and Discussion (https://www.overclock.net/forum/21-benchmarking-software-discussion/)
-   -   Excel Benchmark (https://www.overclock.net/forum/21-benchmarking-software-discussion/1642077-excel-benchmark.html)

ir88ed 11-15-2017 06:58 AM

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:

The Pook 11-15-2017 08:45 AM

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

ir88ed 11-15-2017 09:02 AM

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.

The Pook 11-15-2017 09:10 AM

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

ir88ed 11-15-2017 09:14 AM

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.

mllrkllr88 11-15-2017 12:12 PM

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

bajer29 11-15-2017 12:25 PM

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

daffy.duck 11-15-2017 01:09 PM

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

ir88ed 11-15-2017 01:25 PM

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.

ir88ed 11-15-2017 07:40 PM

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.


All times are GMT -7. The time now is 08:58 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.

User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
vBulletin Security provided by vBSecurity (Pro) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.

vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.