Excel Benchmark - Page 2 - Overclock.net - An Overclocking Community

Forum Jump: 

Excel Benchmark

Reply
 
Thread Tools
post #11 of 201 (permalink) Old 11-15-2017, 08:03 PM
New001
 
Join Date: Feb 2016
Posts: 2,668
Quote:
Originally Posted by mllrkllr88 View Post

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

I think if you have an excel spreadsheet that has performance issues you are using the wrong program though. Most people would move to a proper database if they ran into issues with excel, rather than upgrading all their systems

I wonder if using the Apache POI libraries to interact with the excel files would be a similar comparison to using excel itself. Could probably set up a benchmark without ms excel and try to emulate the way excel would do things.
spinFX is offline  
Sponsored Links
Advertisement
 
post #12 of 201 (permalink) Old 11-15-2017, 10:47 PM - Thread Starter
Linux Lobbyist
 
ir88ed's Avatar
 
Join Date: Jan 2014
Posts: 256
Rep: 18 (Unique: 18)
Quote:
Originally Posted by spinFX View Post

I think if you have an excel spreadsheet that has performance issues you are using the wrong program though. Most people would move to a proper database if they ran into issues with excel, rather than upgrading all their systems

I wonder if using the Apache POI libraries to interact with the excel files would be a similar comparison to using excel itself. Could probably set up a benchmark without ms excel and try to emulate the way excel would do things.

Part of me agrees that there could be a better solution than excel, and I am pretty ignorant of the capabilities of an actual database. I get new datasets frequently; would I set up a database for each of them? I guess that seems like a lot of infrastructure for one-off analyses. Excel allows me to visually see the data structure, which is really helpful with making the formulas for calculations on complex data. Also I do a lot of sorting/formatting/mining of the results, and need flexibility for analysis. For instance, with a data base could I easily do new calculations to pull out all the genes that pass a pairwise ttest between two conditions and are negatively correlated with a given pheontype? That is a two minute job in excel.

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 #13 of 201 (permalink) Old 11-16-2017, 02:20 AM
What should be here ?
 
huzzug's Avatar
 
Join Date: Jun 2012
Posts: 5,283
Rep: 358 (Unique: 256)
Alrighty, I bit and made a little update for the workbook. I basically automated the entire process to not require anyone to manually sort nor to record time on a stopwatch. Just click the "Benchmark". I'll want to make a few more updates for the sheet because I do not know whether it tests all areas of the CPU or only cache (doesn't look like, but the data is still on the file.

Linky

#2 their debt is insane, even for a "diverse field" company. They cannot even afford to service the debt maintenance let alone make an actual dent in the debt itself. - Internet Stranger
huzzug is offline  
Sponsored Links
Advertisement
 
post #14 of 201 (permalink) Old 11-16-2017, 03:02 PM
New to Overclock.net
 
moustang's Avatar
 
Join Date: Nov 2014
Posts: 800
Rep: 72 (Unique: 58)
CPU: 8700K
#CPU cores: 6
CPU clock speed: 5.1GHz
Total system memory: 16GB
Excel ver: 2010
Time to sort (in seconds): 91.19 seconds
moustang is offline  
post #15 of 201 (permalink) Old 11-16-2017, 08:16 PM - Thread Starter
Linux Lobbyist
 
ir88ed's Avatar
 
Join Date: Jan 2014
Posts: 256
Rep: 18 (Unique: 18)
Quote:
Originally Posted by moustang View Post

CPU: 8700K
#CPU cores: 6
CPU clock speed: 5.1GHz
Total system memory: 16GB
Excel ver: 2010
Time to sort (in seconds): 91.19 seconds

Added. A bit surprised that your system scored lower than my 5930K @ 4.8GHz. Nice OC, btw.
I reran the updated benchmark (with huzzug's timer), and got the same result as before, but with more significant figures this time smile.gif
I wonder if the difference is excel 2010 vs 2016? If we end up with a bunch of data, it will be interesting to see if this is a factor.

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 #16 of 201 (permalink) Old 11-16-2017, 08:17 PM - Thread Starter
Linux Lobbyist
 
ir88ed's Avatar
 
Join Date: Jan 2014
Posts: 256
Rep: 18 (Unique: 18)
Quote:
Originally Posted by huzzug View Post

Alrighty, I bit and made a little update for the workbook. I basically automated the entire process to not require anyone to manually sort nor to record time on a stopwatch. Just click the "Benchmark". I'll want to make a few more updates for the sheet because I do not know whether it tests all areas of the CPU or only cache (doesn't look like, but the data is still on the file.

Linky

Huge shout out to huzzug for putting in a timer into the spreadsheet! This is a huge improvement. Thanks huzzug!

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 #17 of 201 (permalink) Old 11-16-2017, 10:17 PM
What should be here ?
 
huzzug's Avatar
 
Join Date: Jun 2012
Posts: 5,283
Rep: 358 (Unique: 256)
Can you change the OP file to the newer link in my post as I made a minor change to how the range is picked for sorting the data.
Edit: Disabled ability to save the worksheet as saving the sheet in the same order that the code sorts gives incorrect results

#2 their debt is insane, even for a "diverse field" company. They cannot even afford to service the debt maintenance let alone make an actual dent in the debt itself. - Internet Stranger
huzzug is offline  
post #18 of 201 (permalink) Old 11-17-2017, 06:06 AM
New to Overclock.net
 
moustang's Avatar
 
Join Date: Nov 2014
Posts: 800
Rep: 72 (Unique: 58)
Quote:
Originally Posted by ir88ed View Post

Added. A bit surprised that your system scored lower than my 5930K @ 4.8GHz. Nice OC, btw.
I reran the updated benchmark (with huzzug's timer), and got the same result as before, but with more significant figures this time smile.gif
I wonder if the difference is excel 2010 vs 2016? If we end up with a bunch of data, it will be interesting to see if this is a factor.

It's a very memory intensive process. I suspect that the difference is down to memory architecture more than CPU speed. Your 4 channel mesh being faster than the 2 channel I have.

But Excel versions could have something to do with it as well. I guess it's time for me to break down and upgrade my Office software.
moustang is offline  
post #19 of 201 (permalink) Old 11-17-2017, 06:16 AM
New to Overclock.net
 
killerhz's Avatar
 
Join Date: Nov 2006
Location: Boston
Posts: 6,063
Rep: 415 (Unique: 341)
CPU: 4790
#CPU cores: 4
CPU clock speed: 4.7GHz
Total system memory: 32GB
Excel ver: 2016
Time to sort (in seconds): 94.91 seconds (had to edit )



killerhz is offline  
post #20 of 201 (permalink) Old 11-17-2017, 08:51 AM
9 Cans of Ravioli
 
The Pook's Avatar
 
Join Date: May 2006
Posts: 16,720
Rep: 1095 (Unique: 634)
Probably should include RAM speed in the results?

And no idea if I was supposed to submit my actual clocks or my turbo clocks so I just submitted my base clocks. Just kind of confused why my i5 6400 is out performing an i5 6500 unless it's down to RAM speed.

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  
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