Here is a comprehensive walkthrough guide for the Eve Online MEWC Case provided by one of our faculty fellows, Diarmuid Early as well as three-time Microsoft Excel World Champion, Andrew Ngai, and Lorenzo Foti, and Jie Gu. The case is available in your ExPrep account. Try it yourself, and if you get stuck, look for the solution in the videos. This case was also featured in MEWC Finals, and you can watch how professionals attempted to solve it.

TASK
EVE Online is a community-driven spaceship game where players are free to choose their own path from countless options. Experience space exploration, immense battles and a thriving player-run economy in an ever-expanding sandbox. Participate in many in-game professions and activities, including war, politics, piracy, trading, and exploration, across 7,000 star systems with hundreds of thousands of other players. EVE is the first game ever to receive its own official Microsoft Excel Add-in.
EVE Online players can mine or purchase various minerals that could later be used to manufacture ships. In this case study we will be using 5 spaceship types and 7 minerals. Different amounts of minerals are required to produce spaceships – the mode advanced the spaceship is, the more minerals will you require.
Another important aspect to consider is a developed economy inside the EVE Online game. The currency of the game is ISK (the Inter-Stellar Kredits). Mineral prices fluctuate on a daily basis. On the “Add-In Output” tab you will be able to find daily market prices for the minerals over the last 6 months.
Sections
00:00 Intro
05:40 Setup / L1 / L2 / B1
09:50 Price history / reading colors / L3
16:10 Bonus 2 / 3
18:58 Asteroid setup / L4
25:24 Level 5
30:27 Level 6 / bonus 4 / 5
40:22 Level 7
Video is divided in parts so you can easily skip to the part that you are stuck on to find out best solution.This is a re-enactment of his performance in the MEWC 2023 Final. He solves it (roughly) the same way as he did on the day and talk through what he was thinking during each stage of the case.
00:00 Intro
01:31 Rules and Case Overview
03:36 Level 1
05:05 Level 2
06:28 Level 3 (Attempt 1)
10:50 Bonus 1
12:28 Level 3 (Attempt 2)
19:13 Level 4
26:41 Level 5? / Bonus 2
30:00 Bonus 3
33:54 Bonus 4
35:42 Level 5?
38:57 Conclusion
Video is divided in parts so you can easily skip to the part that you are stuck on to find out best solution.WALKTHROUGH VIDEO PROVIDED BY LORENZO FOTI
This is his live attempt to solve the case.
WALKTHROUGH VIDEO PROVIDED BY JIE GU
This is his live attempt to solve the case.
This case was played during the MEWC 2023 finals. Top 9 players tried to solve it in elimination type of game where players get eliminated every 5 minutes.
Finalists were:
- Andrew Ngai
- Brandon Moyer
- Michael Clarke
- Willem Gerritsen
- Diarmuid Early
- Adam Carter
- Jakub Pomykalski
- Michael Jarman
- Peter Scharl
MEWC
TAC
EEO