Now I Know: I Guess You Could Say They... Excel

Happy Ides of March, unless you're a Greek emperor, in which case, you may want to watch your back. -- Dan

I Guess You Could Say They... Excel 

Pictured above is a complicated-looking Excel spreadsheet, or, for many of us, the stuff that nightmares are made of. Excel, the spreadsheet software made by Microsoft, is a really powerful tool that lets helps you manipulate data in all sorts of ways -- if you know how to use it. But if you don't, it can be overwhelming and confusing, as even small changes to your tables can cause the software to yell at you with things like #DIV/0 or ###### or the dreaded #REF! error. Many of us avoid Excel like we would the plague.

Those who are really good with Excel -- the people who dream of pivot tables -- they're basically magicians. Unsung ones, though. Or they were until -- until the fall of 2021.

That's when the Financial Modeling World Cup Open -- or the World Cup of Excel -- made its debut.

Starting on November 13, 2021, and into December, thousands of Excel magicians forked over a $50 entrance fee and entered into qualifying rounds. The participants were given 30 minutes to complete a very complicated modeling task, using only Microsoft spreadsheet software and their wits. The 128 competitors with the highest scores advanced to the main event: a real-time, live-streamed face-off against a specific opponent in a single-elimination tournament. After four rounds spaced over a few days (to account for differences in time zones), the Excel Open reached its main event: a two-and-a-half-hour Excelfest featuring some of the greatest athletes (?) in the world. 

You can watch it here -- and join the nearly half a million other people who have checked out the video. The first fifteen minutes or so are introductions, so you may want to skip that and head right to the 16:47 mark, where you'll be greeted with the rules for the round of 8 -- and you'll see, right away, that this isn't the Excel task you're used to. Competitors were asked to create a "ride planning and traffic forecasting application" for a fictional ride-sharing company, and the map provided to the participants included a lot of icons of cars and buildings and the like -- but, as host Bill Jelen notes on the stream "absolutely no numbers." Competitors were then given a series of questions to answer using the map and Excel's tools -- the more questions they get right, the more points the players get. At the end of 40 minutes, if you had more points than your opponent, you advanced to the next round. (Why the Cup organizers decided to make it head-to-head at this stage is strange; as seen here, the third-best finisher was eliminated because he had the unfortunate luck of being paired against the top finisher in the round.)  

In the final round -- it starts at 1:51:06 -- Canadian Micahel Jarman faced off against Australia's Andrew Ngai in a task titled "Knights and Warriors," modeling "possible outcomes between [ . . ] two armies under various scenarios."  The two were neck and neck for the first 12 or so minutes of the 30-minute match, tied at 120 each. But then Andrew began to break away. He ultimately won, dominating Michael by a score of 734 to 280.

The competition was popular enough that it not only earned the Cup another season's worth of competitors but also some TV coverage -- on ESPN3. And it made for some rather compelling television, as the Atlantic recounted. Ngai, the reigning champ, was facing off against a newcomer, American Brittany Deaton, and Deaton was winning, 390-316. But with about three minutes left, Ngai took the lead -- and then, as the Atlantic states, "this is when things got really wild." You can watch the last 90 seconds or so here, but the Atalntic's recap below does it justice:

As the clock approached one minute, Deaton submitted a batch of correct answers and shot up to 610 points. Seconds later, Ngai leapt to 603. Then, Deaton accidentally changed several correct answers and dropped to 566, ceding the lead to Ngai … who promptly began hemorrhaging points himself—592 … 581 … 570 … 559. Fans were losing their minds. “Undo!” one commentator exhorted. “Control Z!” They both did, and suddenly we were right back to Deaton 610, Ngai 603. “Ave Maria!” cried another commentator. Ave Maria indeed: Still behind with five seconds left, Ngai went for the Hail Mary, entering what he would later admit was a random guess and, miraculously, guessing right. A buzzer-beater! Ngai 615, Deaton 610. 
Ngai ended up winning the finals as well, retaining his title and taking home the $10,000 grand prize.

If you want to try to beat him this year, great news: you still can. Registration for the 2023 Cup is open right now (with a 30% early bird discount!), here. And if you're not sure yet but want to give one of the tasks a try, you can do that, too; the Financial Modeling World Cup offers sample tasks from prior competitions for $20, here.

Now I Know is supported by readers like you. Please consider becoming a patron by supporting the project on Patreon. 

Click here to pledge your support. (If you do, in gratitude, you'll have an ad-free Now I Know experience going forward.)

Bonus fact: As of 2017, Microsoft Excel tops out at 1,048,576 rows, according to Mental Floss. How long would it take to scroll all the way down? That year, a YouTuber named Hunter Hobbs decided to find out -- he challenged himself to hold the down arrow key until it hit the bottom and recorded the ultra-mundane task for all of us to see. The end result? A really boring video with a run-time of nine hours, 38 minutes, and two seconds.

From the Archives: The History of the Three-Finger Salute: Why We CTRL-ALT-DEL our way through computer problems.
Like today's Now I Know? Share it with a friend -- just forward this email along.
And if someone forwarded this to you, consider signing up! Just click here.
Share Share
Tweet Tweet
Forward Forward
Archives · Privacy Policy

Copyright © 2023 Now I Know LLC, All rights reserved.
You opted in, at via a contest, giveaway, or the like -- or you wouldn't get this email.

Now I Know is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Some images above via Wikipedia.

Now I Know's mailing address is:
Now I Know LLC
P.O. Box 536
Mt. Kisco, NY 10549-9998

Add us to your address book

Want to change how you receive these emails?
You can update your email address or unsubscribe from this list

Email Marketing Powered by Mailchimp

Key phrases

Older messages

Now I Know: Kaninhoppning -- The World's Cutest Sport?

Thursday, March 16, 2023

I can't think of a cuter one. View this email in your browser · Missed one? Visit the Archives This is a re-run from 2012 and I can't believe I haven't re-shared it since. I link to the

Now I Know: The Little Bit of P-Word in the Coke

Tuesday, March 14, 2023

He got suspended for this? Really? View this email in your browser · Missed one? Visit the Archives The ad at the top features Max Headroom promoting New Coke, two topics about which there are a lot of

Now I Know: This Cupcake Recipe Isn't The Bomb

Monday, March 13, 2023

Deliciously dangerous? Well, yes to the former, no to the latter. View this email in your browser · Missed one? Visit the Archives Sorry, I don't have the recipes here. (I guess, given the

Now I Know: I Think I Found My Favorite Wikipedia Entry

Friday, March 10, 2023

This isn't a red-herring. View this email in your browser · Missed an issue? Click here! If you're new to Now I Know, you'll notice that today's format is different than the rest of the

Now I Know: The Dark History of Groomsmen

Thursday, March 9, 2023

What's a wedding ceremony without a capital crime? View this email in your browser · Missed one? Visit the Archives The Nat Geo article linked below goes into detail on modern-day applications of

Save $200 off CEX + 9 more reasons to register now!

Wednesday, March 29, 2023

Coupon code inside for Creator Economy Expo ($200 off current prices) ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌

Daily Boost: March 29, 2023

Wednesday, March 29, 2023

​ ​ ​ A lot of people are wondering how to use ChatGPT for SEO. So I put together a list of 65 ChatGPT prompts you can use to improve your SEO content and workflow. You may also like: ​Link Whisper, a

ChatGPT for SEO: 20 Best Use Cases

Wednesday, March 29, 2023

Learn how to use ChatGPT to boost your website's SEO with these 20 ready-made ChatGPT prompts Hi Reader, ChatGPT made a lot of buzz. But is it any good for SEO? Spoiler alert: yes. And in

⏰ Cashflow Call in Just 2 Hours (Today 3pm CST)

Tuesday, March 28, 2023

​ ​ ​ Hey CF crew! It's Cashflow call Tuesday and we'll have UA's Ryan Snow on the call for a live Q&A. Don't forget to drop questions in this thread on Circle in advance! We'll

We have the groups for Christian Book Promos (via Facebook)

Tuesday, March 28, 2023

Promote your Christian books with ContentMo ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ enable images to see this Welcome to ContentMo's

Why Victimhood Quashes Creativity

Tuesday, March 28, 2023

Your weekly 5-minute read with timeless ideas on art and creativity intersecting with business and life͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌ ͏‌

Are you bouncing between efficiency and exhaustion?

Tuesday, March 28, 2023

The dangers of unreasonable productivity demands ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌

Now I Know: Here Comes the Story of the Herricanes

Tuesday, March 28, 2023

Today's forecast: Cloudy with less sexism than in the 1970s. View this email in your browser · Missed one? Visit the Archives I love this title and I hope you get the reference. -- Dan Here Comes

❌ Q1 → ✅ Q2 → ✅ Q3 → ✅ Q4

Tuesday, March 28, 2023

Quarter 1 of the year is done! The rest of the year awaits your action: ​ Whatever your yearly goal is, you still have 9 more months to complete it: ❌ Q1: January, February, March​ ​✅ Q2: April, May,

Daily Boost: March 28, 2023

Tuesday, March 28, 2023

​ ​ ​ Today's post includes a helpful explanation about how SEO works for websites, including a simple process to follow for doing better SEO on your own site. You may also like: ​Link Whisper, a