Download Here and read the Readme first: Excel-Benchmark-Tester.zip

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

I would love to have your results. Use the contact form on the menu if you'd like to send them to me. Please and Thanks!

BEFORE OPENING the Excel-Benchmark-Tester.xlsm Macro Enabled sheet. The sheet takes at least a minute to load. While calculating, it can appear as if it crashed or a white screen. That is the way Excel is, so don't close it, just let it run and the screen will return to normal when it finishes.

Open up Blank Excel Workbook. Go to Formulas tab and at far right are Calculation Options - Choose Manual. Go to File > Options > Formula and set to Manual Calculation and Uncheck Recalculate before save, so you can save results in the sheet without long wait recalculating.

Now open the Excel-Benchmark-Tester.xlsm and the first time you will have to enable content (trust) or Unblock in the File's properties. The macros are for the manual calculate from that Microsoft page because by default Excel AUTO-Calculates. Next Click the 'Calculate Formula Time". When you have three scores, Click in the average score cell and click 'Refresh Average'.


(Dynamic count unique - MULTI-COLUMN)
THE FORMULA COPIED DOWN TO ALL ROWS:
=IF(COUNTIFS($B$2:$B2,B2,$A$2:A2,A2)=1,1,0)
Formula result gets bigger and slower the further down it goes.
It is checking all rows above it as well as current row.

CURRENTLY 250,000 rows but can be increased or decreased by copying or deleting rows.
Column A - 50,000 Unique Accounts
Column B - 13 Unique LOB's

Both can be present multiple times, hence the calculation.
1=TRUE, It hasn't been counted yet (First Count, UNIQUE)
0=FALSE, It's already been counted

 

LICENSE:

Copyright 2019 by Derek D. Moore (MIT License)
Free to use and Commercialize at your own risk. If you publish this, please attribute me, BUT, ATTRIBUTION IS NOT REQUIRED.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

 

 

TIP CRYPTO: ADA, ALGO, BNB Binance Coin, BTC, DOGE, ETH, LTC, OMI, Harmony ONE, SOL, USDC, USDT (ERC20), VET, XLM & XRP cryptocurrencies (in all lowercase) to: systemadmin.crypto

Supported Wallets & Apps for sending to: systemadmin.crypto

Decrypt.co

Elizabeth Warren Urges Zuckerberg to Halt Facebook's Crypto Wallet Novi

Facebook finally launched it crypto wallet, only to be admonished by Senator Elizabeth Warren.


First Bitcoin Futures ETF Trades Nearly $1 Billion in One Day

The first-ever Bitcoin ETF has hit the market. And it nearly broke the trading record for any debuting ETF.


Mining Bitcoin for Profit Is Getting Harder. Here's Why

Hashrate and price are both on the way up.


Coinbase Inks Sponsorship Deal With NBA, WNBA

Coinbase follows rival FTX with a big push into sports marketing.


Martha Stewart Is Now Selling Ethereum NFTs—And Carving CryptoPunks Into Pumpkins

The lifestyle entrepreneur seeks success in yet another business endeavor: festive Ethereum NFT collectibles.


Stan Lee NFTs Capture the Creator’s Essence in Classic Comic Covers

Artist Rob Prior collaborated on the portraits with Lee before the legendary Marvel creator’s death. Now they’re Ethereum NFTs.


Facebook Turns to Coinbase, Paxos for Novi Crypto Wallet

From today, people in the U.S. and Guatemala can buy Paxos Dollars through a pilot version of Facebook's digital wallet Novi.


Grayscale Bitcoin Trust Hits 20% Discount as Firm Files for ETF Conversion

The Grayscale Bitcoin Trust (GBTC) is facing a 20% discount on the underlying asset. The firm is now hoping to pivot to a Bitcoin ETF.


Stablecoins Don’t Need New Regulations: Chamber of Digital Commerce

The crypto advocacy group in Washington, D.C. has said stablecoins should not face new regulations just because they represent new technology.


Polychain Capital Joins $32M Investment in DeFi Lending Protocol Element Finance

Crypto venture capital giant Andreessen Horowitz also backed the protocol.


Riot Games Vets Raise $90M for Patron, a 'Spectrum of Play' Web 3 Fund

A new investment fund bets that the convergence of Web 3 and gaming will accelerate.


Revolut Adds No Fee Crypto Trading in Push for U.S. Market

Revolut announced it will charge no fees on crypto transactions on up to $200,000 of trades per month.


Andreessen Horowitz Vets Launch $110M Crypto 'Ownership' Fund

Variant, which has backed the likes of Uniswap and Mirror, is launching a new fund dedicated to projects that harness the ownership incentive of tokens.


NFTs Go Mainstream in London Art Gallery's AI Exhibition

The Deeep AI Art Fair in London, England, showcased NFTs and generative art alongside works exploring the role of AI in art.


Crypto Giant Galaxy Raises $325M for 'Content and Technology' Fund

Galaxy Interactive has raised a massive new fund to invest in crypto projects at the intersection of finance and tech.


Tether Lending Stablecoins Backed by Bitcoin, Ethereum: Celsius CEO

Tether has allegedly been lending stablecoins backed by cryptocurrency deposits, according to new reports.


Digital Assets Weaken US Sanctions Regime: Treasury Dept

The Biden administration has warned that digital assets undermine the sanctions regime in the United States.


Invesco Drops Bitcoin Futures ETF Filing

Invesco has pulled the plug on its Bitcoin futures ETF application, hours before ProShares’ competing product debuts on the NYSE.


These Bitcoin Futures ETFs May Be Next to Launch

Now that the ProShares Bitcoin Strategy ETF will begin trading, what other Bitcoin futures ETFs are around the corner?


Bitcoin Company Bakkt Closes First Day of Trading Down 6.4%

Shares in BKKT opened at $9.41.


Bitcoin Futures Open Interest Hits Record High on CME

Open interest now stands at a record $3.6 billion.


Why a CryptoPunks Owner Turned Down $9.5M in Ethereum for His NFT

Can you put a price on a growing brand in the NFT space? Maybe, but not for the owner of this Punk avatar.


Interactive Brokers Group Launches Crypto Trading for U.S. Financial Advisors

Last month the firm opened crypto trading to U.S. residents, now it’s green-lit crypto trading for Registered Financial Advisors too.


NY Attorney General: Unregistered Crypto Lenders Must Shut Down

The New York Attorney General’s office today announced “additional investigations” into unregistered crypto lending and borrowing platforms.


Bitcoin Company Bakkt Begins Trading on New York Stock Exchange

Bakkt, the digital asset platform, makes its debut today as a public company on the New York Stock Exchange under the ticker BKKT.


ProShares Bitcoin Futures ETF Trades Tuesday: What You Need to Know

The new Bitcoin ETF is a landmark occasion for the crypto industry. Here's a plain English guide on how it works and how to buy it.


Fitch Ratings Issues Stablecoin Warning

“Big three” credit rating agency Fitch Ratings has warned that stablecoins could impact securities markets.


Grayscale Filing Bitcoin ETF Application to ‘Force the SEC’s Hand’: Report

Grayscale Investments is reportedly planning to file an application that will see the firm’s flagship Bitcoin trust convert into a spot ETF.


Where Is Facebook's Cryptocurrency?

Facebook announced Libra in June 2019. More than two years later, it's not here, and it aims to enter the crowded stablecoin market. What's the point?


Indexed Finance Claims to Have Found Hacker Who Stole $16 Million

The project is the latest DeFi protocol to be hit with a monster attack.