{"video_id":"fp_WGnG76fq3H","title":"Excel is now an eSport","channel":"Techquickie","show":"Techquickie","published_at":"2023-11-10T21:13:00.022Z","duration_s":335,"segments":[{"start_s":0.0,"end_s":4.24,"text":"It's fair to say most of us don't like spreadsheets, but the people who do like them","speaker":null,"is_sponsor":0},{"start_s":4.88,"end_s":10.24,"text":"like them a lot. And while many of us use Microsoft Excel in our day-to-day work,","speaker":null,"is_sponsor":0},{"start_s":10.24,"end_s":14.72,"text":"an elite few have adapted the world's most popular spreadsheet software","speaker":null,"is_sponsor":0},{"start_s":14.72,"end_s":22.72,"text":"into an e-sports phenomenon. In 2022, the Excel World Championship debuted as part of ESPN's","speaker":null,"is_sponsor":0},{"start_s":22.72,"end_s":29.28,"text":"The Ocho, an annual showcase of lower-profile sports like axe throwing, corgi racing, and of","speaker":null,"is_sponsor":0},{"start_s":29.28,"end_s":34.8,"text":"course, the Slippery Stair Climb. The vast majority of viewers had never even conceived of","speaker":null,"is_sponsor":0},{"start_s":34.8,"end_s":40.64,"text":"competitive Excel before, because there are some levels of nerdy that are simply beyond mere mortal","speaker":null,"is_sponsor":0},{"start_s":40.64,"end_s":46.8,"text":"ken. But the sport was popular enough that it was renewed for the 2023 Ocho and will be holding","speaker":null,"is_sponsor":0},{"start_s":46.8,"end_s":54.32,"text":"its finale in the Las Vegas HyperX e-sports arena this December with a prize pool of $10,000 across","speaker":null,"is_sponsor":0},{"start_s":55.28,"end_s":61.6,"text":"But Excel as an e-sport didn't appear out of nowhere fully formed in 2022. It came out of an","speaker":null,"is_sponsor":0},{"start_s":61.6,"end_s":67.2,"text":"existing culture of financial modeling competitions. Basically, these are tournaments where participants","speaker":null,"is_sponsor":0},{"start_s":67.2,"end_s":72.8,"text":"must create a financial forecast for a fictional company based on a provided data set in, what","speaker":null,"is_sponsor":0},{"start_s":72.8,"end_s":77.84,"text":"else, Excel. The organizers of the Financial Modeling World Championship were looking for a","speaker":null,"is_sponsor":0},{"start_s":77.84,"end_s":83.6,"text":"way to turn these competitions into a spectator sport, because apparently the cultural mainstream","speaker":null,"is_sponsor":0},{"start_s":83.6,"end_s":88.96,"text":"is unenthusiastic about debt service coverage ratios, which is a real shame. They gradually","speaker":null,"is_sponsor":0},{"start_s":88.96,"end_s":94.32,"text":"adapted the format to make the contests more exciting and accessible, and in mid-2021,","speaker":null,"is_sponsor":0},{"start_s":94.32,"end_s":100.96,"text":"they went viral. Because, you know, pandemic. Finally, ESPN expressed an interest, and the","speaker":null,"is_sponsor":0},{"start_s":100.96,"end_s":108.72,"text":"FMWC Open was streamed on ESPN3 in December 2021. The next year, Microsoft sponsored the competition,","speaker":null,"is_sponsor":0},{"start_s":108.72,"end_s":113.36,"text":"lending it their own name, and making it the Microsoft Excel World Championship.","speaker":null,"is_sponsor":0},{"start_s":113.68,"end_s":120.72,"text":"But what does a round of competitive Excel actually look like? And how do you Excel enough to win?","speaker":null,"is_sponsor":0},{"start_s":120.72,"end_s":125.76,"text":"Each round of an Excel tournament has a unique challenge, like tabulating the results of a","speaker":null,"is_sponsor":0},{"start_s":125.76,"end_s":130.72,"text":"series of hypothetical elections or projecting the outcome of a game of whack-a-mole. Participants","speaker":null,"is_sponsor":0},{"start_s":130.72,"end_s":135.68,"text":"have to answer a series of 100 increasingly difficult questions about the puzzle in only 30","speaker":null,"is_sponsor":0},{"start_s":135.68,"end_s":141.12,"text":"minutes. That's roughly one answer every 18 seconds, but that assumes that the players are","speaker":null,"is_sponsor":0},{"start_s":141.12,"end_s":145.52,"text":"answering them one at a time, which they aren't, unless time is short and they're desperate.","speaker":null,"is_sponsor":0},{"start_s":145.52,"end_s":150.64,"text":"Questions are typically organized into five batches of 20 questions, and the dominant strategy","speaker":null,"is_sponsor":0},{"start_s":150.64,"end_s":156.32,"text":"by experienced players is to create a single formula that will solve an entire batch. This means","speaker":null,"is_sponsor":0},{"start_s":156.32,"end_s":162.32,"text":"that a player's score can stagnate for long periods, then jump rapidly. It can even go down,","speaker":null,"is_sponsor":0},{"start_s":162.32,"end_s":168.8,"text":"which means it's time for a quick undo. But that might not save novice players who get stuck and","speaker":null,"is_sponsor":0},{"start_s":168.8,"end_s":174.24,"text":"wind up with a big fat zero out of a thousand. The winner is whoever answers all the questions","speaker":null,"is_sponsor":0},{"start_s":174.24,"end_s":179.68,"text":"correctly first or whoever has the most points when the 30 minutes are up. The puzzles can vary","speaker":null,"is_sponsor":0},{"start_s":179.68,"end_s":185.44,"text":"a lot in terms of difficulty, so the points players receive are typically adjusted to normalize scores","speaker":null,"is_sponsor":0},{"start_s":185.44,"end_s":191.36,"text":"across games. An infamous 2021 case based on the game's civilization was so difficult that the","speaker":null,"is_sponsor":0},{"start_s":191.36,"end_s":196.56,"text":"winner managed to get just eight points total, narrowly edging out his opponent who managed to","speaker":null,"is_sponsor":0},{"start_s":196.56,"end_s":202.08,"text":"accumulate a paltry six. Both of them were guessing, which can be executed quickly and","speaker":null,"is_sponsor":0},{"start_s":202.08,"end_s":208.08,"text":"efficiently using the formula rand between to cover large batches of unknown answers. Familiarity","speaker":null,"is_sponsor":0},{"start_s":208.08,"end_s":213.28,"text":"with keyboard shortcuts is obviously a necessary skill, to the point that player BIOS will list","speaker":null,"is_sponsor":0},{"start_s":213.28,"end_s":217.92,"text":"their favorite shortcut. And there's some hot controversy in the meta over whether competitive","speaker":null,"is_sponsor":0},{"start_s":217.92,"end_s":223.68,"text":"players should ever use a mouse to navigate. Advanced players with a fluency and visual","speaker":null,"is_sponsor":0},{"start_s":223.68,"end_s":229.36,"text":"basic might even code on the fly. Unsurprisingly, the game tends to be dominated by accountants,","speaker":null,"is_sponsor":0},{"start_s":229.36,"end_s":237.2,"text":"actuaries, mathematicians, and engineers. You know, the alpha nerds. The format of games can vary as","speaker":null,"is_sponsor":0},{"start_s":237.2,"end_s":242.64,"text":"well, with tournaments sometimes featuring 1v1 elimination matches and other times 8 player","speaker":null,"is_sponsor":0},{"start_s":242.64,"end_s":249.2,"text":"battle royales. It's brutal. A panel of commentators narrate the game, dissect the outcome,","speaker":null,"is_sponsor":0},{"start_s":249.2,"end_s":254.08,"text":"and introduce and interview the players before and after the fact. And at in-person events,","speaker":null,"is_sponsor":0},{"start_s":254.08,"end_s":259.84,"text":"there's often an electric crowd excited to see their favorite Excel battler perform the spreadsheet","speaker":null,"is_sponsor":0},{"start_s":259.84,"end_s":265.84,"text":"equivalent of a mounted elbow drop off the top rope. And it's not a sport without merch. They've","speaker":null,"is_sponsor":0},{"start_s":265.84,"end_s":271.76,"text":"got shirts like this invalid formula, divided by zero design, or this one with all your favorite","speaker":null,"is_sponsor":0},{"start_s":271.76,"end_s":278.16,"text":"formulas. I'm partial to equal count ifs, open, parent, closed, parent, myself. The Microsoft","speaker":null,"is_sponsor":0},{"start_s":278.16,"end_s":283.2,"text":"Excel World Championship isn't the only gaming arena where you'll find Excel. It's had a long,","speaker":null,"is_sponsor":0},{"start_s":283.2,"end_s":288.64,"text":"if eccentric history in gaming, usually acting as an external, supplementary tool for complex","speaker":null,"is_sponsor":0},{"start_s":288.64,"end_s":294.48,"text":"RPGs that require advanced data management. Eve Online, the game sometimes called spreadsheets","speaker":null,"is_sponsor":0},{"start_s":294.48,"end_s":299.76,"text":"in space, actually got an official Excel plug-in earlier this year, much to the excitement of its","speaker":null,"is_sponsor":0},{"start_s":299.76,"end_s":304.72,"text":"player base. Not to mention that people have been programming games directly into Excel for decades,","speaker":null,"is_sponsor":0},{"start_s":304.72,"end_s":310.16,"text":"like Snake, Minesweeper, and even Battleship. If there's anything we can learn from a sweaty","speaker":null,"is_sponsor":0},{"start_s":310.16,"end_s":314.64,"text":"crowd cheering on their favorite Excel champion as they formulate their way to victory, it's that","speaker":null,"is_sponsor":0},{"start_s":314.64,"end_s":320.8,"text":"human beings can find joy in literally anything. And it brings me great joy to see you here at the","speaker":null,"is_sponsor":0},{"start_s":320.8,"end_s":325.2,"text":"end of the video. Welcome! Thanks for watching, like the video if you like it, dislike it if","speaker":null,"is_sponsor":0},{"start_s":325.2,"end_s":329.12,"text":"you disliked it, check out our other videos, comment below with video suggestions, and don't","speaker":null,"is_sponsor":0},{"start_s":329.12,"end_s":335.68,"text":"forget to subscribe and follow and plug us into your spreadsheet of choice. I know you have it.","speaker":null,"is_sponsor":0}],"full_text":"It's fair to say most of us don't like spreadsheets, but the people who do like them like them a lot. And while many of us use Microsoft Excel in our day-to-day work, an elite few have adapted the world's most popular spreadsheet software into an e-sports phenomenon. In 2022, the Excel World Championship debuted as part of ESPN's The Ocho, an annual showcase of lower-profile sports like axe throwing, corgi racing, and of course, the Slippery Stair Climb. The vast majority of viewers had never even conceived of competitive Excel before, because there are some levels of nerdy that are simply beyond mere mortal ken. But the sport was popular enough that it was renewed for the 2023 Ocho and will be holding its finale in the Las Vegas HyperX e-sports arena this December with a prize pool of $10,000 across But Excel as an e-sport didn't appear out of nowhere fully formed in 2022. It came out of an existing culture of financial modeling competitions. Basically, these are tournaments where participants must create a financial forecast for a fictional company based on a provided data set in, what else, Excel. The organizers of the Financial Modeling World Championship were looking for a way to turn these competitions into a spectator sport, because apparently the cultural mainstream is unenthusiastic about debt service coverage ratios, which is a real shame. They gradually adapted the format to make the contests more exciting and accessible, and in mid-2021, they went viral. Because, you know, pandemic. Finally, ESPN expressed an interest, and the FMWC Open was streamed on ESPN3 in December 2021. The next year, Microsoft sponsored the competition, lending it their own name, and making it the Microsoft Excel World Championship. But what does a round of competitive Excel actually look like? And how do you Excel enough to win? Each round of an Excel tournament has a unique challenge, like tabulating the results of a series of hypothetical elections or projecting the outcome of a game of whack-a-mole. Participants have to answer a series of 100 increasingly difficult questions about the puzzle in only 30 minutes. That's roughly one answer every 18 seconds, but that assumes that the players are answering them one at a time, which they aren't, unless time is short and they're desperate. Questions are typically organized into five batches of 20 questions, and the dominant strategy by experienced players is to create a single formula that will solve an entire batch. This means that a player's score can stagnate for long periods, then jump rapidly. It can even go down, which means it's time for a quick undo. But that might not save novice players who get stuck and wind up with a big fat zero out of a thousand. The winner is whoever answers all the questions correctly first or whoever has the most points when the 30 minutes are up. The puzzles can vary a lot in terms of difficulty, so the points players receive are typically adjusted to normalize scores across games. An infamous 2021 case based on the game's civilization was so difficult that the winner managed to get just eight points total, narrowly edging out his opponent who managed to accumulate a paltry six. Both of them were guessing, which can be executed quickly and efficiently using the formula rand between to cover large batches of unknown answers. Familiarity with keyboard shortcuts is obviously a necessary skill, to the point that player BIOS will list their favorite shortcut. And there's some hot controversy in the meta over whether competitive players should ever use a mouse to navigate. Advanced players with a fluency and visual basic might even code on the fly. Unsurprisingly, the game tends to be dominated by accountants, actuaries, mathematicians, and engineers. You know, the alpha nerds. The format of games can vary as well, with tournaments sometimes featuring 1v1 elimination matches and other times 8 player battle royales. It's brutal. A panel of commentators narrate the game, dissect the outcome, and introduce and interview the players before and after the fact. And at in-person events, there's often an electric crowd excited to see their favorite Excel battler perform the spreadsheet equivalent of a mounted elbow drop off the top rope. And it's not a sport without merch. They've got shirts like this invalid formula, divided by zero design, or this one with all your favorite formulas. I'm partial to equal count ifs, open, parent, closed, parent, myself. The Microsoft Excel World Championship isn't the only gaming arena where you'll find Excel. It's had a long, if eccentric history in gaming, usually acting as an external, supplementary tool for complex RPGs that require advanced data management. Eve Online, the game sometimes called spreadsheets in space, actually got an official Excel plug-in earlier this year, much to the excitement of its player base. Not to mention that people have been programming games directly into Excel for decades, like Snake, Minesweeper, and even Battleship. If there's anything we can learn from a sweaty crowd cheering on their favorite Excel champion as they formulate their way to victory, it's that human beings can find joy in literally anything. And it brings me great joy to see you here at the end of the video. Welcome! Thanks for watching, like the video if you like it, dislike it if you disliked it, check out our other videos, comment below with video suggestions, and don't forget to subscribe and follow and plug us into your spreadsheet of choice. I know you have it."}