KinChungE

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

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

i5 2400

下載 (86.51 KB)
i5 2400

2017-4-5 10:00

冰水半糖

注意風險,怕就唔好Download,我對VBA無意見w

s84292

唔知遲D會唔會見到有WORD 同POWERPOINT Benchmark
可以測埋GPU

tsoi923

下載 (125.36 KB)

2017-4-5 12:19

公司機

ms06s_char

我都玩下公司機先...
Windows XP SP3
粒u係E8300@2.83GHz...唔係Pentium III Xeon

下載 (73.16 KB)

2017-4-5 13:57

CPU 98%

下載 (146.3 KB)

2017-4-5 13:57

kennyleunghk

4粒核得90%
公司機黎講算快 今晚返去再跑下部E5 2683v3

下載 (47.37 KB)

2017-4-5 15:06

windkit

o甘其實個code就係個file入面ge 怕有野/有興趣睇可以自己開

因為好奇想知點解用唔晒100% CPU都開左個code睇睇
除左拎CPU Info果段之外 其實都係excel平時ge formula (IF, RAND, SUM)
個parallelization由excel自己做 用唔晒CPU係M$問題...

tsoi923

我都玩下公司機先...
Windows XP SP3
粒u係...唔係Pentium III Xeon


CPU 98%   ...
ms06s_char 發表於 2017-4-5 13:58

呢個SPEC個CHROME開多幾個分頁都會hang
ps:我公司果部都會間歇性HANG機