作者: jimmy2046 時間: 2017-4-4 15:40 標題: Microsoft Excel Benchmark for HKEPC
本帖最後由 jimmy2046 於 2017-4-8 14:36 編輯
I have developed a benchmark in VBA which can test the performance of various CPUs in Microsoft Excel.
The benchmark is about estimating the value of Pi by using Monte Carlo simulation. My program generates 35,000,000 points which fall randomly on a unit square. Then we determine how many points are in the unit circle. The estimated value of Pi is simply four times the number of points on unit circle divided by the total number of points.
Excel Benchmark:
https://drive.google.com/file/d/0B1k05LP-ZG6xZjhVak9KMEJyZTA/view?usp=sharing
I am looking forward to benchmarks of the latest CPUs. Please share the results in this thread and these valuable information will help us decide whether it is worth upgrading our existing computers.
Ranking as of 08 Apr 2017:
https://www.hkepc.com/forum/attachment.php?aid=1972316&k=bd901feef5c0bcb42c480cbdf674f2d9&t=1781386423&sid=3NrI80krVA

https://www.hkepc.com/forum/attachment.php?aid=1973264&k=67cabdb5092113fcd72cd74735740bbb&t=1781386423&sid=3NrI80krVA

https://www.hkepc.com/forum/attachment.php?aid=1973267&k=9bb50a4eec7fc310588f1a554b20a943&t=1781386423&sid=3NrI80krVA

作者: s20021139 時間: 2017-4-4 17:19
I have developed a benchmark in VBA which can test the performance of various CPUs in Microsoft Exce ...
jimmy2046 發表於 2017-4-4 15:40
AMD 7850k @3.2G (65W)
https://www.hkepc.com/forum/attachment.php?aid=1972331&k=c93668a203f17439f8a16107c93cad3c&t=1781386423&sid=3NrI80krVA

作者: marcofung 時間: 2017-4-4 17:41
本帖最後由 marcofung 於 2017-4-4 17:44 編輯
回覆 1# jimmy2046
AMD FX6300, 4.4 Ghz
會唔會有用緊Ryzen既ching跑一跑, 心思思想換機
https://www.hkepc.com/forum/attachment.php?aid=1972335&k=c9eb06442a27ae107bbe3a8624930fca&t=1781386423&sid=3NrI80krVA

作者: rictom 時間: 2017-4-4 18:29
[img][/img]回覆 1# jimmy2046
https://www.hkepc.com/forum/attachment.php?aid=1972347&k=86291386072c3ad8cf4c77937b99e5a7&t=1781386423&sid=3NrI80krVA

作者: 隨機人生 時間: 2017-4-4 19:18
提示: 作者被禁止或刪除 內容自動屏蔽
作者: jimmy2046 時間: 2017-4-4 20:21
What's your CPU utilization when you ran the test? What were the CPU frequency when 14 cores were used?
回覆 5# 隨機人生
作者: qcmadness 時間: 2017-4-4 20:23
What's your CPU utilization when you ran the test? What were the CPU frequency when 14 cores were us ...
jimmy2046 發表於 2017-4-4 20:21
就咁睇似超左
作者: 隨機人生 時間: 2017-4-4 20:42
提示: 作者被禁止或刪除 內容自動屏蔽
作者: peter88625 時間: 2017-4-4 20:45
好慢

https://www.hkepc.com/forum/attachment.php?aid=1972390&k=3589304dd1592470fdf4f89549864894&t=1781386423&sid=3NrI80krVA

作者: jimmy2046 時間: 2017-4-4 20:50
本帖最後由 jimmy2046 於 2017-4-4 20:52 編輯
I am afraid that my program is not good enough so the full potential of your CPU may mot be shown.
回覆 8# 隨機人生
作者: 隨機人生 時間: 2017-4-4 20:58
提示: 作者被禁止或刪除 內容自動屏蔽
作者: jimmy2046 時間: 2017-4-4 21:21
I fixed a bug which did not show '32-bit' of Excel version.
回覆 2# s20021139
作者: PT100 時間: 2017-4-4 21:44
回覆 1# jimmy2046
https://www.hkepc.com/forum/attachment.php?aid=1972412&k=3ddf9b70772f691924a64fe56951488d&t=1781386423&sid=3NrI80krVA

作者: hoktong 時間: 2017-4-4 21:46
本帖最後由 hoktong 於 2017-4-4 21:48 編輯
only 91% usage of CPU during test
https://www.hkepc.com/forum/attachment.php?aid=1972416&k=088e14e40cf7e5572cb47b76c277770d&t=1781386423&sid=3NrI80krVA

作者: 日行千里 時間: 2017-4-4 21:49
本帖最後由 日行千里 於 2017-4-4 21:50 編輯
AMD Ryzen 1700x
ASUS PRIME B350-PLUS (全部default setting)
32GB Kingston 2400Mhz
Intel SSDPEKKW512G7 (M2 512GB)
Inno3D GTX960 4GB



作者: cidtch 時間: 2017-4-4 21:51
本帖最後由 cidtch 於 2017-4-4 21:55 編輯
回覆 1# jimmy2046
https://www.hkepc.com/forum/attachment.php?aid=1972418&k=311cee5592a991eccace9590f5d0b0c3&t=1781386423&sid=3NrI80krVA

作者: jimmy2046 時間: 2017-4-4 22:09
Do you have Excel 2016? I used Excel 2010 before and found out that Excel 2010 was a bit faster when running my program.
回覆 13# PT100
作者: eddychoy04 時間: 2017-4-4 22:16
i7 6700K @ 4.5 GHz.
https://www.hkepc.com/forum/attachment.php?aid=1972419&k=b4d867cec59905e68c4987a06882a0bf&t=1781386423&sid=3NrI80krVA

作者: macis 時間: 2017-4-4 22:17
有無毒??
作者: jimmy2046 時間: 2017-4-4 22:21
I wrote that program. I promise you it is not malicious.
作者: PT100 時間: 2017-4-4 22:22
回覆 17# jimmy2046
Sorry, I can't be help since it's a little bit sensitive to install unauthorized software on this PC !!!
I am still force to use Office 2010 right now cause still got numbers of licence on hand

作者: jimmy2046 時間: 2017-4-4 22:27
Oh I see. Nevertheless, the performance of your machine is very impressive.
回覆 21# PT100
作者: macis 時間: 2017-4-4 22:31
收到
作者: HY 時間: 2017-4-4 22:37
dont know how to test
作者: macis 時間: 2017-4-4 22:39
係唔係無開macro?
作者: HY 時間: 2017-4-4 22:40
唔係幾識點用
作者: macis 時間: 2017-4-4 22:41
我都無download
作者: eddychoy04 時間: 2017-4-4 22:41
download to your PC, click "Benchmark tab" --->Run.
作者: eddychoy04 時間: 2017-4-4 22:47
AMD Ryzen 1700x
ASUS PRIME B350-PLUS (全部default setting)
32GB Kingston 2400Mhz
Intel SSDPEKKW512G7 ...
日行千里 發表於 2017-4-4 21:49
1700X 跑贏我粒 6700K。
作者: s20021139 時間: 2017-4-4 22:49
I fixed a bug which did not show '32-bit' of Excel version.
回覆 s20021139
jimmy2046 發表於 2017-4-4 21:21
哈,無論如何, 7850k 都唔入流, 不過行既時候個utilization都係80%左右
作者: ms06s_char 時間: 2017-4-4 22:52
回覆 18# eddychoy04
都係6700K @ 4.5GHz, 快你一秒多d
https://www.hkepc.com/forum/attachment.php?aid=1972431&k=b6e2c210f020ed77516ecb1b5265ebdc&t=1781386423&sid=3NrI80krVA

作者: kp1419 時間: 2017-4-4 22:54
i7 920 @3.49GHz
Excel 2010 64 Bit
During execution, the CPU utilization is around 80 %.
https://www.hkepc.com/forum/attachment.php?aid=1972432&k=11982ab18fb480cfa90b63f656982d62&t=1781386423&sid=3NrI80krVA

作者: bighead 時間: 2017-4-4 23:04
Office 2013
R7 1700@3.9GHz
https://www.hkepc.com/forum/attachment.php?aid=1972435&k=5526ea3c9ea961253bed935d5d5f2c20&t=1781386423&sid=3NrI80krVA

作者: eddychoy04 時間: 2017-4-4 23:05
1700 都贏 6700K.
作者: p805061010 時間: 2017-4-4 23:06
i7 6700K@4.4GHz
16GB DDR4 2400
好似比你地慢啲

https://www.hkepc.com/forum/attachment.php?aid=1972437&k=666e879861fe9cb1b848de7042db1c9f&t=1781386423&sid=3NrI80krVA

作者: jimmy2046 時間: 2017-4-4 23:12
The performance of Ryzen 1700 is in line with many tests done such as Cinebench R15 and Sysmark 2012.
回覆 33# bighead
作者: PowerShot 時間: 2017-4-4 23:14
我唔cap 啦, 52.6s, PII 1045T@3.64GHz
作者: jimmy2046 時間: 2017-4-4 23:39
Please help us post the screen cap.
回覆 37# PowerShot
作者: PowerShot 時間: 2017-4-4 23:46
之前我開左好多program run, 宜家熄曬跑多一次
https://www.hkepc.com/forum/attachment.php?aid=1972445&k=9a02b0f4950cea380898e83853563c88&t=1781386423&sid=3NrI80krVA

作者: jimmy2046 時間: 2017-4-4 23:47
Thank you.
回覆 39# PowerShot
作者: 寂寞的FSY 時間: 2017-4-4 23:56
臨退役前一試@3.95GHz
https://www.hkepc.com/forum/attachment.php?aid=1972451&k=4cf7ef3dd79398317514909a4e693ea3&t=1781386423&sid=3NrI80krVA

作者: HY 時間: 2017-4-5 00:01
I7 6700K
https://www.hkepc.com/forum/attachment.php?aid=1972452&k=5da01a71a1b2c528e6046cf44f315d6d&t=1781386423&sid=3NrI80krVA

作者: housing 時間: 2017-4-5 00:29
玩下先!
https://www.hkepc.com/forum/attachment.php?aid=1972474&k=fe877ecf19a2803a4e721e73d6da8a64&t=1781386423&sid=3NrI80krVA

作者: jimmy2046 時間: 2017-4-5 00:33
Do you have Excel 2016?

回覆 43# housing
作者: housing 時間: 2017-4-5 00:38
回覆 44# jimmy2046
Sorry, I only have Office 2007.
作者: jimmy2046 時間: 2017-4-5 00:39
Wow, we have so enthusiastic responses from our community!! Thank you all! Once we gather enough data, I will start consolidate the results and give you an easier comparison of various CPU's performance.
作者: 白白 時間: 2017-4-5 00:39
I7 6700K
https://www.hkepc.com/forum/attachment.php?aid=1972478&k=8876d3da503fb371ab4d4669433382c2&t=1781386423&sid=3NrI80krVA

作者: jimmy2046 時間: 2017-4-5 00:41
I7 6700K is pretty fast!
作者: kevinho2006 時間: 2017-4-5 01:50
detect唔到cpu
i5 5257u
https://www.hkepc.com/forum/attachment.php?aid=1972496&k=5c63c3a7461d05d1101538bc0a9c0129&t=1781386423&sid=3NrI80krVA

作者: myricky 時間: 2017-4-5 02:27
提示: 作者被禁止或刪除 內容自動屏蔽
作者: skydreamer888 時間: 2017-4-5 02:38
Macbook Pro 15" Mid 2015 with CPU upgraded
https://www.hkepc.com/forum/attachment.php?aid=1972502&k=6832b9019560c6235a8629d50e593c50&t=1781386423&sid=3NrI80krVA

作者: 然然 時間: 2017-4-5 03:48
點信你?VBA既source code呢?
作者: ricky1992 時間: 2017-4-5 04:11
本帖最後由 ricky1992 於 2017-4-5 04:27 編輯
1230v2
32
64
https://www.hkepc.com/forum/attachment.php?aid=1972506&k=3a687ceeb5e3cdca4366155a248c98b2&t=1781386423&sid=3NrI80krVA

https://www.hkepc.com/forum/attachment.php?aid=1972507&k=4fb7e4049bb49ea18df5ce286f1e9a34&t=1781386423&sid=3NrI80krVA

作者: askh22 時間: 2017-4-5 09:09
仲慢過我?
https://www.hkepc.com/forum/attachment.php?aid=1972512&k=5c13dc2ea7f4cd9c525e641b44bc8086&t=1781386423&sid=3NrI80krVA

作者: KinChungE 時間: 2017-4-5 09:18
本帖最後由 KinChungE 於 2017-4-5 09:20 編輯
唔信既就唔好run, 咁簡單
人地冇收錢, 冇必要俾source code你睇
補圖, 公司dell廠機
https://www.hkepc.com/forum/attachment.php?aid=1972513&k=8fa50b42dca4744808b00b955cd7a532&t=1781386423&sid=3NrI80krVA

作者: bighead 時間: 2017-4-5 09:20
回覆 46# jimmy2046
幾有趣, 但係咪真係有意義地比較到? 我run果陣全程都係得74% load
作者: KinChungE 時間: 2017-4-5 09:25
我估樓主專登唔用哂全部thread, 只用n-1條thread
廢事full load的話容易俾background task影響分數
作者: 燕飛 時間: 2017-4-5 09:31
回復 55 #KinChungE
VBA / MACRO 漏洞多真係唔好信
via HKEPC Reader for Android
作者: KinChungE 時間: 2017-4-5 09:33
呢D唔可以話漏洞, 係功能
VBA本身就可以做到好似exe咁, 直接call好多Windows API
冇理由佢多功能就話佢多漏洞
作者: jimmy2046 時間: 2017-4-5 09:44
I don't know why my program consumed only about 83% CPU time when it was executed in Excel 2016. The utilization rate was higher when it was run in Excel 2010.
May be it was due to the design of Excel?
回覆 57# KinChungE
作者: KinChungE 時間: 2017-4-5 09:44
I don't know why my program consumed only about 83% CPU time when it was executed in Excel 2016. Th ...
jimmy2046 發表於 2017-4-5 09:44
咁可能係喎
我用Excel 2013都係得87% CPU (4C8T, 佢用得7T)
作者: jimmy2046 時間: 2017-4-5 09:53
Thank you for your suggestions. There are so many experts hiding.
Your tweak involves displaying a changing bar chart. It may use some of the resources from your display card.
Since I want to test the performance of CPU only, it is better to keep other factors out.
借用Jimmy2046版友Benchmark Excel, 作出以下改良
1)實時顯示測試時間及完成度
2)加上"Stop"制
3)由於加上1 ...
myricky 發表於 2017-4-5 02:27
作者: jimmy2046 時間: 2017-4-5 10:00
i5 2400
https://www.hkepc.com/forum/attachment.php?aid=1972528&k=e5ab338a963055848353c6f651f4c1d2&t=1781386423&sid=3NrI80krVA

作者: 冰水半糖 時間: 2017-4-5 11:17
注意風險,怕就唔好Download,我對VBA無意見w
作者: s84292 時間: 2017-4-5 11:25
唔知遲D會唔會見到有WORD 同POWERPOINT Benchmark
可以測埋GPU
作者: tsoi923 時間: 2017-4-5 12:20
公司機

https://www.hkepc.com/forum/attachment.php?aid=1972562&k=fe43ebe26251d70caca7cb3c7d336550&t=1781386423&sid=3NrI80krVA

作者: ms06s_char 時間: 2017-4-5 13:58
我都玩下公司機先...
Windows XP SP3
粒u係E8300@2.83GHz...唔係Pentium III Xeon
CPU 98%
https://www.hkepc.com/forum/attachment.php?aid=1972566&k=1a1fa0218fb2672bb17267bd1d79fc1b&t=1781386423&sid=3NrI80krVA

https://www.hkepc.com/forum/attachment.php?aid=1972567&k=d667f6d9b0edd85e0b2ae88bf9325a20&t=1781386423&sid=3NrI80krVA

作者: kennyleunghk 時間: 2017-4-5 15:06
4粒核得90%
公司機黎講算快
https://www.hkepc.com/forum/attachment.php?aid=1972575&k=870cd0ec83d17ef17777a05797725f46&t=1781386423&sid=3NrI80krVA

作者: windkit 時間: 2017-4-5 16:05
o甘其實個code就係個file入面ge 怕有野/有興趣睇可以自己開
因為好奇想知點解用唔晒100% CPU都開左個code睇睇
除左拎CPU Info果段之外 其實都係excel平時ge formula (IF, RAND, SUM)
個parallelization由excel自己做 用唔晒CPU係M$問題...
作者: tsoi923 時間: 2017-4-5 16:29
呢個SPEC個CHROME開多幾個分頁都會hang
ps:我公司果部都會間歇性HANG機
作者: ms06s_char 時間: 2017-4-5 16:41
回覆 70# tsoi923
HANG就唔會既...佢都2G RAM, 不過個HDD 就老化緊...成日都load 唔停...估計係load 緊pagefile, 不過熄左行chrome 會唔夠ram...
作者: KinChungE 時間: 2017-4-5 17:19
回覆 tsoi923
HANG就唔會既...佢都2G RAM, 不過個HDD 就老化緊...成日都load 唔停...估計係load 緊pagef ...
ms06s_char 發表於 2017-4-5 16:41
Chrome只開一個分頁都食200-300MB RAM啦
作者: 321 時間: 2017-4-5 17:27
呢次真係真正文書記啦,不過excel好似對多核優化得差
via HKEPC Reader for Android
作者: John Lam 時間: 2017-4-5 17:29
咁得意,我又試試先
係咪最多只可以用到85% CPU Resource ?
作者: macis 時間: 2017-4-5 17:48
John哥都有興趣
作者: akam7777 時間: 2017-4-5 18:01
好似比佢快dd.....
https://www.hkepc.com/forum/attachment.php?aid=1972607&k=225465aa80e160e51df0dbd462fb809e&t=1781386423&sid=3NrI80krVA

作者: PT100 時間: 2017-4-5 18:44
回覆 60# jimmy2046
For your reference:-
Even I use Excel 2010, CPU consumed only 89% during the test!
作者: hhpower 時間: 2017-4-5 20:35
提示: 作者被禁止或刪除 內容自動屏蔽
作者: eddychoy04 時間: 2017-4-5 20:49
回覆 76# akam7777
cpu 0000?
作者: kpfong 時間: 2017-4-5 21:06
A8-3820 CPU ~ 85%
https://www.hkepc.com/forum/attachment.php?aid=1972644&k=b4a7dc3eff13c1c8b6c3f3fc7e7896a6&t=1781386423&sid=3NrI80krVA

作者: KinChungE 時間: 2017-4-5 21:10
Mac OS X
CPU係錯既, 真身係6800K @ 3.9GHz all core
分數好差
https://www.hkepc.com/forum/attachment.php?aid=1972646&k=a4773b4f8584175b157a24429c049af5&t=1781386423&sid=3NrI80krVA

作者: akam7777 時間: 2017-4-5 21:11
X99--8C16T@3.1(14nm),
認吾到粒U
作者: eddychoy04 時間: 2017-4-5 21:16
OK thanks.
作者: kpfong 時間: 2017-4-5 21:29
A10-7800 CPU ~80%
https://www.hkepc.com/forum/attachment.php?aid=1972647&k=7893721c531319a32db7f6951584d077&t=1781386423&sid=3NrI80krVA

作者: ptalentk 時間: 2017-4-5 23:43
很舊的機,CPU 90%左右
https://www.hkepc.com/forum/attachment.php?aid=1972695&k=626053d764bfb6de43abd423a17f37c9&t=1781386423&sid=3NrI80krVA

作者: danny9428 時間: 2017-4-5 23:52
無聊玩玩...
i7 5820k @ 4.1ghz (uncore 3.6ghz)
32GB DDR4 Ram 2800mhz (16-18-18-42 1T)
Excel 2010
https://www.hkepc.com/forum/attachment.php?aid=1972696&k=529967401e0f5dd59c6b0b036a073b60&t=1781386423&sid=3NrI80krVA

https://www.hkepc.com/forum/attachment.php?aid=1972697&k=adc28f471dde68db8ae80db63298629c&t=1781386423&sid=3NrI80krVA

作者: chromechan 時間: 2017-4-5 23:53
係咪用得70%?
作者: kzhkbeta 時間: 2017-4-5 23:56
excel 2013
i5 4460 90% usage
39s
作者: jimmy2046 時間: 2017-4-5 23:56
Probably he was not using Windows 7, 8, 8.1, 10.
作者: Passer2k 時間: 2017-4-6 00:01
我唔明, 咁多人屋企自己機有裝office嘅?
個測試我都好想試, 但係我無裝office八年有多... (雖然部notebook都仲有個超舊版...)
作者: jimmy2046 時間: 2017-4-6 00:06
Use Windows. Show us the full force of i7 6800K!

作者: jimmy2046 時間: 2017-4-6 00:07
Xeon E5?
作者: jimmy2046 時間: 2017-4-6 00:10
Could you please upload the screen capture of your mark?
作者: chromechan 時間: 2017-4-6 00:14
Average 70% Load
作者: KinChungE 時間: 2017-4-6 00:33
總會裝黎睇門口
有時想打幾隻字, 改少少format print出黎, 有個word都方便好多
作者: jjzhu 時間: 2017-4-6 07:33
https://www.hkepc.com/forum/attachment.php?aid=1972745&k=f28c3f6cc975931cff8e68249250d877&t=1781386423&sid=3NrI80krVA

作者: jimmy2046 時間: 2017-4-6 09:15
Did you overclock your CPU? Do you mind running the benchmark at stock speed?
無聊玩玩...
i7 5820k @ 4.1ghz (uncore 3.6ghz)
32GB DDR4 Ram 2800mhz (16-18-18-42 1T)
Excel 2010
...
danny9428 發表於 2017-4-5 23:52
作者: astrial 時間: 2017-4-6 15:51
Core i7 5600U
Excel 2010 32-bit
89-93% CPU utilization
https://www.hkepc.com/forum/attachment.php?aid=1972818&k=2f2d1afbedcad48790de5747f1feda4b&t=1781386423&sid=3NrI80krVA

作者: bigcat1123 時間: 2017-4-6 16:15
Time of this machine ( Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz ,32-bit Excel 2010)
公司機
https://www.hkepc.com/forum/attachment.php?aid=1972820&k=3f490a580c60771f939a49ef566d2d37&t=1781386423&sid=3NrI80krVA

作者: JACK2120 時間: 2017-4-6 18:17
I5 4460
Office 2016
https://www.hkepc.com/forum/attachment.php?aid=1972835&k=08027717877112182ca89f14339659f0&t=1781386423&sid=3NrI80krVA



