more perf figures

WP wouldn’t let me add this as a comment so I made a new post…

 

Microsoft Excel for Office 365 MSO (16.0.10813.20004) 32 bit
Office Insider Program
Grid not visible
0.7578125
0.6953125
0.71875
0.7578125
0.71875
0.7265625
0.7265625
0.703125
0.71875
0.7265625
Grid visible
1.757813
1.710938
1.703125
1.695313
1.710938
1.703125
1.664063
1.6875
1.679688
1.703125

Processor: Intel(R) Core(TM) i7-5820K CPU @3.30GHzRam:
32.0 GBWindows 10 Home 64-bit

———————————————————–

Results (c.47 hours since last reboot):
4.015625
4.484375
4.402344
4.324219
4.144531
4.214844
4.441406
4.332031
4.453125
4.351563

Results (after rebooting):
4.738281
5.519531
4.609375
4.527344
4.640625
4.652344
4.640625
4.636719
4.734375
4.667969

Following on from above but gridlines hidden:
5.015625
5.140625
4.988281
5.105469
5.179688
5.238281
5.054688
5.042969
5.050781
5.039063

System:
OS Name Microsoft Windows 10 Pro
Version 10.0.17134 Build 17134
System Model Surface Pro 3
System Type x64-based PC
Processor Intel(R) Core(TM) i5-4300U CPU @ 1.90GHz, 2501 Mhz

Installed Physical Memory (RAM) 8.00 GB

Office:
Microsoft Excel 2013 (15.0.5041.1000) MSO (15.0.5031.1000) 32 bit
Part of Microsoft Office 365

Rubberduck Version 2.2.6672.28001 loaded.

———————————————————

Excel 2k3 (11.0.8169)
Windows XP Pro (5.1, Build 2600)
AMD Athlon XP64 Cpu 3200+ 2.8GHz
2048MB RAM

0.15625
0.296875
0.3125
0.3125
0.3125
0.328125
0.296875
0.3125
0.3125
0.3125

——————————————————–

EXCEL 2016

‘i7-3770 3.4GHz 16GB 64-bit OS, SSD & HD

Windows (32-bit) NT 10.00 Excel 16.0 Build 10325
Seed 3.1 Select:True
3.585938
3.4375
3.527344
3.316406
3.390625
Seed 3.1 Select:False
0.078125
0.078125
0.078125
0.0625
0.09375

EXCEL 2010

Windows (32-bit) NT 6.02 Excel 14.0 Build 7212
Seed 3.1 Select:True
0.9453125
0.9140625
0.9179688
0.90625
0.9101563
Seed 3.1 Select:False
2.734375E-02
0.046875
0.03125
0.046875
0.03125

CODE

Option Explicit
‘Simon Murphy

‘i7-3770 3.4GHz 16GB 64-bit OS, SSD & HD

Public Sub multiLoop()

Debug.Print Evaluate(“INFO(“”OSVERSION””)”), “Excel ” & Application.Version & ” Build ” & Application.Build
RepeatCellEntryTest 3.1, True
RepeatCellEntryTest 3.1, False
End Sub

Public Sub RepeatCellEntryTest(seed As Double, bSelect As Boolean)

——————————————————————–

Intel i7-7700HQ @ 2.8 GHz
32 GB RAM
Windows Pro 64 bit V1803
Excel 2016 (O365) Build 10325.20118

1:
1.289063
1.167969
1.152344
1.144531
1.148438
1.140625
1.148438
1.15625
1.167969
1.175781

2:
1.371094
1.308594
1.28125
1.257813
1.269531
1.25
1.210938
1.207031
1.277344
1.238281

Advertisements

3 Responses to “more perf figures”

  1. Joe Serdakowski Says:

    I did a study once having installed Excel 2003, 2007, 2010 and 2013 on the same computer. Running the same macro:
    2003 ~ 30 seconds
    2007 ~ 60 seconds
    2010 ~ 90 seconds
    2013 ~ 120 seconds

    Progress??

  2. pugwonk Says:

    I wouldn’t do performance testing on insider builds. They often ship with debug stuff still enabled, and perf is about the last thing that gets fixed in the dev cycle.

  3. Simon Says:

    pugwonk – do you ever think they will get to removing the debug stuff from 2016??? Every version I have tried performs like a debug build.
    Or will that be Office 2019?

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


%d bloggers like this: