- Details
- Written by Derek Moore
- Hits: 1372
UPDATE: Thanksgiving, Nov. 28, 2019. Microsoft has opened a case and is investigating the formula decrease in speed since Oct. 2019.
UPDATE: Nov. 2nd, 2019 - It appears one of Microsoft's Update to either Windows or Office has slowed down the formulas by at least 50%. We are investigating.
This is a Real World CPU Performance Checker (Excel). This is about as real as it gets. This is a real formula businesses uses to calculate unique orders, accounts, whatever by different business lines. It uses as many cores and as much memory as it can. There are 13 unique Business lines within the one company. There are 50,000 Unique accounts randomized into 250,000 rows along with the line of business to which they belong. The formula below calculates all rows and keeps results from row above it, so the lower it gets, the more it has to track and formula time increase as it goes further.
Download Here and read the Readme first: Excel-Benchmark-Tester.zip