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:
https://docs.google.com/spreadsheets/d/e/2PACX-1vSVrwXT3OC748bJnLNpUiBxBbRNoLBmH_XaimWmXs2nq4a9ojVAWJJch5VQxRe927_Z_LYf51FNchUi/pubhtml?gid=0&single=true&widget=true&headers=false
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:
https://docs.google.com/spreadsheets/d/e/2PACX-1vSVrwXT3OC748bJnLNpUiBxBbRNoLBmH_XaimWmXs2nq4a9ojVAWJJch5VQxRe927_Z_LYf51FNchUi/pubhtml?gid=0&single=true&widget=true&headers=false