Here is a comprehensive walkthrough guide for the MECC July 2023 Speed Challenge provided by two of our faculty fellows, David Brown, Eric Kelley and Diarmuid Early. The case is available in your ExPrep account. Try it yourself, and if you get stuck, look for the solution in the videos.

WALKTHROUGH VIDEO PROVIDED BY DAVID BROWN
WALKTHROUGH VIDEO PROVIDED BY DIARMUID EARLY
WALKTHROUGH VIDEO PROVIDED BY ERIC KELLEY
Using a simple case that asks competitors to manipulate various series of numbers, I talk through the common structure of “levels” and “games” that appear in most eSports cases that we see in competition. Then, in this video, I work through the case using basic “brute force” techniques.
WALKTHROUGH VIDEO PROVIDED BY ERIC KELLEY
Using a simple case that asks competitors to manipulate various series of numbers, I show viewers how to use a data table to loop through the games within a level to quickly convert a series inputs to their respective outputs.
WALKTHROUGH VIDEO PROVIDED BY ERIC KELLEY
Using a simple case that asks competitors to manipulate various series of numbers, I show viewers how to use the let function to work through a multi-step process in a single cell.
MEWC
TAC
EEO