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

Forum Jump: 

Excel Benchmark

Reply
 
Thread Tools
post #161 of 201 (permalink) Old 01-27-2018, 11:06 AM
OC...D
 
Jpmboy's Avatar
 
Join Date: Apr 2012
Location: Philadelphia
Posts: 26,503
Rep: 1281 (Unique: 565)
Quote: Originally Posted by AlphaC View Post
I remain skeptical since the 30 seconds time seems the same time as what Excel gives after it has already been sorted.

Have you looked at the datavalues before and after sorting? Maybe the VBA timer isn't working properly in Libreoffice (i.e. timing from a different point in the sort) or perhaps it doesn't recalculate anything (more likely).
already posted the answer to your question. scroll up.

but, this is offtopic since this bench thread is excel based.
Enjoy

ASUS Z370/Z390 Motherboard Support Thread, Coffee Lake OC Guide
GPUs For Sale
X299
(27 items)
x99
(18 items)
Z370
(19 items)
CPU
7980XE
CPU
7740X
CPU
9900X
Motherboard
ASUS Rampage VI Apex
Motherboard
Gigabyte Aorus G9
Motherboard
Rampage VI Extreme Omega
GPU
2x Nvidia Titan V
GPU
GTX 1080
GPU
2 2080Ti FE / EK Vector Blocks
RAM
G. Skill 2x(2x8GB) 3600c15 @4000c16
RAM
Team Group
RAM
Two 4x8GB GS 3600c16 kits @ 4000c16
Hard Drive
INtel Optane 900P
Hard Drive
2x256 Plextor Raid 0
Hard Drive
WD Raptor
Hard Drive
Samsung Sm 961
Power Supply
Corsair AX1500i
Power Supply
EVGA 850 G3
Cooling
Aquacomputer GiGant 1680 (4x420)
Cooling
Koolance EXC-800
Case
Microcool Banchetto 101 (Alu)
Case
Corsair 570X
Operating System
Win 10 Pro
Operating System
Win 7 Pro
Monitor
ROG Swift
Keyboard
Ducky
Mouse
Spatha
CPU
6950X
Motherboard
ASUS Rampage V Extreme-10
GPU
Titan Xp
GPU
Titan Xp
RAM
G Skill 8x8GB 3200c14 @3400c13
Hard Drive
Samsung 960 Pro
Optical Drive
ASUS BR/DVD/CD
Power Supply
Corsair AX1500i
Cooling
2x360 Aq Copper Rads
Cooling
Aquaero 6
Cooling
Koolance ERM-3K3U (9-fan mora)
Cooling
Ek Full Cover MB waterblock
Case
CaseLabs Mercury S8
Operating System
Win 10 Pro
Operating System
Win 7 Pro
Monitor
AGON 32 inch
Keyboard
Das Pro
Mouse
Logitech G700
CPU
8700K
CPU
8086K
Motherboard
ASUS Maximus X Apex
GPU
GTX 1070Ti FTW2
RAM
2x8 GB G.Skill 4400c19
RAM
G.Skill 3600c16 4x6GB
Hard Drive
Intel 750
Optical Drive
PLextor DVD/CD
Power Supply
Corsair AX1500i
Power Supply
Corsair HX 1200i
Power Supply
Seasonic Titanium 850W
Cooling
360Rad + Chiller
Cooling
Koolance ERM-3K3U
Case
Corasir 570
Operating System
Win 10
Operating System
Windows 7 Pro
Monitor
55" 4K
Keyboard
HyperX Alloy FPS Pro
Mouse
SteelSeries Rival
▲ hide details ▲


Jpmboy is offline  
Sponsored Links
Advertisement
 
post #162 of 201 (permalink) Old 01-27-2018, 12:27 PM
⤷ αC
 
AlphaC's Avatar
 
Join Date: Sep 2012
Posts: 11,174
Rep: 904 (Unique: 590)
I got 46 seconds using Sandy Bridge @ 4.6 so it's in line with your result.

There's something else at play here.

Manually using the filter arrow (that looks like V) and "sort ascended" from first column is also 45 seconds or so.

I did notice a 2nd core was being used more than in Excel , with the 3rd and 4th cores also lightly loaded around 10-15%.

It's about a quarter of the time versus the 32 bit version of Excel 2016 (~180 seconds) and about 40% of the time versus the 64 bit version of Excel 2016 ( ~ 120 seconds).

---

LibreOffice Multithreading findings:
https://www.phoronix.com/scan.php?pa...Calc-Threading
Quote:
Tor Lillqvist and Dennis Francis of Collabora appear to be leading this charge. Their first stab at Calc parallelism notes that for now formula group calculations are done in parallel threads. This is done when OpenCL is not being used and the CPU_THREADED_CALCULATION is set. For now it's hidden behind an environment variable, but hopefully soon enough it will become the default.
Collabora Libreoffice presentation on multithreading https://people.gnome.org/~michael/blog/2017-02-04.html

I suspect for ir88ed's workflow perhaps the use of Calc could be possible if it's a home computer.
Attached Thumbnails
Click image for larger version

Name:	Libreoffice bench.PNG
Views:	27
Size:	237.7 KB
ID:	60449  


► Recommended GPU Projects: [email protected] , [email protected] (FP64) (AMD moreso) ► Other notable GPU projects: [email protected] (Nvidia), GPUGrid (Nvidia) ► Project list



Last edited by AlphaC; 01-27-2018 at 01:06 PM. Reason: Libreoffice Multithreading findings
AlphaC is offline  
post #163 of 201 (permalink) Old 03-08-2018, 06:47 AM
Overclocker
 
JackCY's Avatar
 
Join Date: Jun 2014
Posts: 9,990
Rep: 339 (Unique: 240)
115.62s on 4.5Ghz 4690K 16GB RAM 2400 CL11 (stock RAM clocks right now and other stuff idling in background), Excel 32bit for compatibility reasons, 1 run nothing more.

CPU: 4690K
#Cores: 4
#Threads: 4
CPU clock speed: 4.5GHz
Total system memory: 16GB
memory speed: 2400MHz CL11
Excel version: 2016 32bit 16.0.4639.1000
32/64 bit: 32bit
time to sort (in seconds): 115.62s

LibreOffice is not compatible with Excel macros, who the hell knows it runs it should just crash or fail for anything even remotely complex. Using spreadsheets to process and sort large data is a bad idea to begin with.

Last edited by JackCY; 03-08-2018 at 06:55 AM.
JackCY is offline  
Sponsored Links
Advertisement
 
post #164 of 201 (permalink) Old 03-08-2018, 07:11 AM
New to Overclock.net
 
Roxborough's Avatar
 
Join Date: Aug 2010
Location: Manchester, UK
Posts: 1,697
Rep: 64 (Unique: 58)
CPU:i7-5600U
#Cores: 2 (4 logical)
CPU clock speed: 2.6GHz
Total system memory: 16GB
memory speed:1600mhz
Excel version: 1801 (Build 9001.2171 Click-to-Run)
32/64 bit: 64-bit
time to sort (in seconds): 223.33 seconds

This is my work laptop, I've not restarted it in months so this maybe a skewed result. Dell Lattitude E5550.

Thadeous: Courtney, will you make funny faces to entertain me?

[Courtney makes a variety of weird faces which causes Thadeous to clap with glee, until he gives a smile in the shape of a triangle]

Thadeous: No! Never triangle-face! I *hate* triangle face! It scares me!
Roxborough is offline  
post #165 of 201 (permalink) Old 03-08-2018, 09:33 AM - Thread Starter
Linux Lobbyist
 
ir88ed's Avatar
 
Join Date: Jan 2014
Posts: 256
Rep: 18 (Unique: 18)
Quote: Originally Posted by JackCY View Post
115.62s on 4.5Ghz 4690K 16GB RAM 2400 CL11 (stock RAM clocks right now and other stuff idling in background), Excel 32bit for compatibility reasons, 1 run nothing more.
Using spreadsheets to process and sort large data is a bad idea to begin with.
I am not sure I understand the aversion to using spreadsheets, and I have run into this with more than a few people. I will use R for complex calculation. I am not afraid to use scripting to deal with data formatting/merging/analysis. But if I download a large dataset and just want to drop labels on it, calculate ttests and fold changes across groups, and do some sorts, what the heck is wrong with excel? I could do it in R, but why? It would take longer and it is more difficult.

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 #166 of 201 (permalink) Old 03-22-2018, 09:42 AM
New to Overclock.net
 
Join Date: Mar 2018
Posts: 1
Rep: 0
Lenovo Thinkpad w550s
CPU: ACPI x64-based PC i7-5600 @ 2.60 GHz
#Cores: 4
CPU clock speed: 2.60 GHz
Total system memory: 12 GB
memory speed: 1600 MHz
Excel version: MS Excel 2016 (MSO (16.0.9029.2253) 64-bit
32/64 bit: 64 bit
time to sort (in seconds): 197.13 (1st test), 252.7 (2nd test)
sdcanuck is offline  
post #167 of 201 (permalink) Old 03-29-2018, 06:34 AM
New to Overclock.net
 
Happy Hepo's Avatar
 
Join Date: Oct 2017
Location: Germany
Posts: 10
Rep: 1 (Unique: 1)
New Rig:
CPU: TR 1920X
#Cores: 12 (24)
CPU clock speed: 3,7 GHz
Total system memory: 32 GB
memory speed: 3200 MHz
Excel version: 2016
32/64 bit: 32
time to sort (in seconds): 216,25

Laptop:
CPU: i7-4702MQ
#Cores: 4(8)
CPU clock speed: 3,1 GHz
Total system memory: 16GB
memory speed: 1600 MHz
Excel version: 2016
32/64 bit: 32
time to sort (in seconds): 155,02
Happy Hepo is offline  
post #168 of 201 (permalink) Old 03-29-2018, 12:39 PM
⤷ αC
 
AlphaC's Avatar
 
Join Date: Sep 2012
Posts: 11,174
Rep: 904 (Unique: 590)
Happy Hepo, unless you need the 32-bt version for add-ins you should probably try it on 64-bit Excel.

► Recommended GPU Projects: [email protected] , [email protected] (FP64) (AMD moreso) ► Other notable GPU projects: [email protected] (Nvidia), GPUGrid (Nvidia) ► Project list


AlphaC is offline  
post #169 of 201 (permalink) Old 04-04-2018, 08:05 AM
New to Overclock.net
 
Happy Hepo's Avatar
 
Join Date: Oct 2017
Location: Germany
Posts: 10
Rep: 1 (Unique: 1)
Rerun:
CPU: TR 1920X
#Cores: 12 (24)
CPU clock speed: 3,7 GHz
Total system memory: 32 GB
memory speed: 3200 MHz
Excel version: 2016
32/64 bit: 64
time to sort (in seconds): 129,73
Happy Hepo is offline  
post #170 of 201 (permalink) Old 04-26-2018, 11:56 AM
⤷ αC
 
AlphaC's Avatar
 
Join Date: Sep 2012
Posts: 11,174
Rep: 904 (Unique: 590)
Stock R7 2700X on X370 board with XFR2 enabled (all core ~ 3.9GHz to 4.1GHz under full load and 4.35GHz XFR2 single and 2 core boost)
8 core 16 thread
RAM amount: 2x8GB
DDR4 3200 CL16 16-16-16-30

~180 seconds on 32-bit Excel 2016...
Click image for larger version

Name:	excel benchmark R7 2700X.PNG
Views:	60
Size:	319.9 KB
ID:	164769

~170 seconds with PBO (Precision Boost overdrive) enabled
Click image for larger version

Name:	Ryzen 7 2700X PBO.PNG
Views:	58
Size:	341.8 KB
ID:	164953

~14.5 to 15 seconds for DATA1000
Click image for larger version

Name:	DATA1000.PNG
Views:	52
Size:	415.1 KB
ID:	164841Click image for larger version

Name:	excel benchmark R7 2700X (data1000).PNG
Views:	50
Size:	383.4 KB
ID:	164849

also Excel trader (more parallel)
Name:  excel trader bench R7 2700X.PNG
Views: 310
Size:  25.1 KB

Excel trader with PBO enabled
Name:  Exceltrader PBO.PNG
Views: 299
Size:  16.5 KB

► Recommended GPU Projects: [email protected] , [email protected] (FP64) (AMD moreso) ► Other notable GPU projects: [email protected] (Nvidia), GPUGrid (Nvidia) ► Project list



Last edited by AlphaC; 04-26-2018 at 02:37 PM. Reason: add DATA1000
AlphaC 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