Our Other Brands
Individuals & Teams Las Vegas • Nov 30 - Dec 2, 2026 Excel Esports Hyperx arena Prize Fund • $34,050 Individuals & Teams Las Vegas • Nov 30 - Dec 2, 2026 Excel Esports hyperx arena Prize Fund • $34,050
Get Hyped →

MECC APRIL 2024 ROAD TO LAS VEGAS CHALLENGE

Here is a comprehensive walkthrough guide list for the MECC April 2024 Road To Las Vegas Challenge provided by one of our faculty fellows, Diarmuid Early, as well as three-time Microsoft Excel World Champion, Andrew Ngai, and Lorenzo Foti, and Excel Wizard. The case is available in your ExPrep account. Try it yourself, and if you get stuck, look for the solution in the videos. You can also watch how this case was played during live battle.

TASK

FMWC has founded a new shipping company. This company operates a lot of routes on a fictitious map.
Your task is to calculate different aspects of freight shipping and logistics business.

Fuel Cost
The fuel cost is always equal to the distance between two cities in cells * the weight of the ship.
Besides Level 7, fuel cost is the only relevant type of cost in this Case.

The Ships
There are four different ship types. Each has a different capacity (in Units), Base Weight (own weight of an empty ship) and Maximum Weight, and Speed. The Weight of a specific ship is equal to the Base Weight + Units loaded * Weight of one Unit. You can’t load partial units on the ships.
The speed is only relevant on Level 5 and Bonus 4, it displays how many blocks a ship can travel in one hour.

Distance calculation (Level 5-7)
Starting with Level 5 you are required to calculate the distance to a specific port. Note that all shipping routes start at Port Excel (E13). The distance between two ports is equal to the minimum number of cells on the map. A ship can travel one cell up, down, right or left, but it cannot travel diagonally. Do not include the starting cell but include the final cell in your calculations.

Canals (Level 7)
There are two different canals displayed on the map. The Indirect Canal and the Table Canal.
Large ships can’t travel through any of the canals. Big ships can travel through the Table Canal, but not the Indirect Canal. Small and medium ships can travel through both canals.
Passing through one canal costs 150.

WALKTHROUGH VIDEO PROVIDED BY ANDREW NGAI

This is his live attempt at solving the case during the Excel Battle.

WALKTHROUGH VIDEO PROVIDED BY DIARMUID EARLY

This is his live attempt at solving the case during the Excel Battle. Unfortunately, he got the start time wrong, started 15 minutes late, and only had time to finish half the questions.

WALKTHROUGH VIDEO PROVIDED BY LORENZO FOTI

WALKTHROUGH VIDEO PROVIDED BY EXCEL WIZARD

Here is a guide how to move along available path without Circular reference with Single cell formula, as well as live attempt at solving the case.

LIVE BATTLE WITH FOUR PARTICIPANTS

The same case was featured in MEWC Road to Las Vegas 2024 Battle IV. Here is a recording of live battle where four participants were working on solving this case:

  • Jason Sindler (USA)
  • Jérémie Verdonck (France)
  • Nicholas Fox (USA)
  • Jakub Pomykalski (Poland)


The game was hosted by Giles Male and David Brown.

0
0
Your Cart
Your cart is emptyReturn to Shop