Here is a comprehensive walkthrough guide for the Command And Calculate Solution Model provided by one of our faculty fellows, Diarmuid Early, and Lorenzo Foti. The case is available in your ExPrep account. Try it yourself, and if you get stuck, look for the solution in the videos.

TASK
In “Excel Battlefield”, you take on the role of a commander. Every level consists of 20 distinct battlegrounds, each with an initial power for your army and specific power levels for the 20 enemy armies you’ll face. After the battle your army’s power increases by adding the power of the defeated enemy army. The objective is to calculate and predict the outcomes of each battleground based on the provided scenarios. Performance is assessed through required fields in each level, with some levels also featuring bonus questions.
WALKTHROUGH VIDEO PROVIDED BY DIARMUID EARLY
Solving the case with Dynamic Arrays
WALKTHROUGH VIDEO PROVIDED BY LORENZO FOTI
This is his live attempt to solve the case.
MEWC
TAC
EEO