The Financial Modeling World Cup (FMWC) is the largest e-sport event for Excel players worldwide, where they will compete on the familiar Microsoft spreadsheet platform. . This tournament came to an end on December 11 with Andrew “NGOAT” Nga as the champion, after he defeated his opponent Michael Jarman with an overwhelming score of 734 – 280. (You can learn more about it. in this article).
But how did this event turn out in the end? How does a “battle” on the Excel platform happen? Let’s try to find out through the FMWC final that took place a few days ago.
Purpose and competition rules of FMWC
Before entering the world of numbers and calculations in Excel, we must understand the player’s task when participating in this tournament: They will receive a task as a case study, simulated or inspired. inspired by real situations. Based on the given data, they need to build the required financial model and answer all the accompanying questions. All must be presented in one Excel sheet.
Each of these case studies will include 1 to 5 related worksheets, along with about 6 to 15 questions that must be answered by applying formulas in Excel. The more difficult the question, the higher the score. In addition, the question format is also very flexible, can be multiple choice or fill in the blanks, but never in a paragraph format.
Two contestants will confront each other online for a given time limit (usually 30 minutes) to solve the same problem and based on the final score to decide the winner.
Find out the progress of 1 “match” in FMWC through this year’s final
This year’s final between Andrew Ngai and Michael Jarman has a rather strange and interesting topic: Knights and Warriors. Instead of an ordinary financial case study, this time the organizers decided to take inspiration from the game Might and Magic. Before following the specific developments in the video below, here are some information you need to know.
First, the player will take on the role of strategist for a fictional kingdom called Winsia. The kingdom was in constant conflict with its neighbour, Loblenia. Using the latest updated version of Medieval Excel AD1365 (which is the Microsoft Excel of the Office 365 suite), they needed to create a model with the ability to calculate the outcome of battles with various conditions, based on on given rules. No matter how you calculate it, the final valid answer must be the remaining “health” (HP) of the winning side.
So what are those conditions? First, both Winsia and Loblenia will only be able to use 3 types of troops: Knight (Knight), Infantry (Infantry) and Archer (Archer). Each type of unit has its own stats, including HP, attack power (AP) and fire power (SP – only applicable to Archer).
Second, like many other video games, the battle between the two countries will take place in many turns. During each turn, both sides attack at the same time (not take turns). The total damage that each side deals is calculated by the formula: AP x number of troops involved in that turn. Damage will take effect in the order Infantry → Knight → Archer.
For example, assuming each Loblenia Infantry has 30HP, if the Winsian unit deals 1000 damage, 33 Loblenia Infantry will be killed and 1 wounded. In the next turn, this wounded Infantry can continue to attack with the same AP, but the HP is reduced to only 20. (because 30 x 33 + 10 = 1000, this Infantry lost 10 health in the previous turn).
Finally, the battle between Wisia and Loblenia will be divided into 5 stages with different difficulty. The first stage consists of simple and basic calculations about the HP and damage each side can do in different situations, with different numbers of troops. Phase 2 will only have Infantry join the fight. Phase 3 will include Infantry and Knight. Stage 4 is the calculation in case one side moves faster than the other in the same round. And finally, all 3 armies joined the battle.
With such rules, Andrew Ngai and Michael Jarman built a HP calculation model for the winning side, please watch the video below:
Events of the final of FMWC 2021, where Excel masters from all over the world compete.
If you are interested and want to solve FMWC exam questions yourself, you can order their case studies (including those of Knights and Warriors) here, for 10 USD/case. In addition, they also provide a lot of sample case studies here so those who do not have the conditions or the opportunity to participate in the tournament can try. However, it should be noted that these case studies only provide answers and do not show how, because each player can apply different sets of formulas, depending on their level and habit of using Excel. surname.