[測試] 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
Pi.jpg

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:

Ranking (as of 08 Apr 2017).gif

Ranking (Chart) (as of 08 Apr 2017).jpg

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)
Capture.JPG

TOP

本帖最後由 marcofung 於 2017-4-4 17:44 編輯

回覆 1# jimmy2046
AMD FX6300, 4.4 Ghz

會唔會有用緊Ryzen既ching跑一跑, 心思思想換機
Capture.JPG

TOP

[img][/img]回覆 1# jimmy2046

擷取.PNG (22.52 KB)

i5 4690K@ 4.0GHz

擷取.PNG

TOP

提示: 作者被禁止或刪除 內容自動屏蔽

TOP

What's your CPU utilization when you ran the test? What were the CPU frequency when 14 cores were used?

回覆 5# 隨機人生

TOP

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


就咁睇似超左

TOP

提示: 作者被禁止或刪除 內容自動屏蔽

TOP

好慢

benchmark.png

TOP

本帖最後由 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# 隨機人生

TOP