Excel is a versatile piece of software and has a lot of the characteristics of a programming language. The techniques used to build financial models can also be applied to solve other problems using Excel. By exploring the use of Excel for recreational problem solving we can often develop or pick up new techniques and methods that prove useful in traditional modelling situations.
During this session, join two financial modelling experts and recreational Excel modelling enthusiasts Dan Mayoh and Diarmuid Early as they walk through their contrasting approaches to solving a well-known TV game show game by using Excel in a programmatic way.
The game show Letters and Numbers (Australia) / Countdown (UK) / Des Chiffres et des Lettres (France) includes a ‘Letters’ game where 9 letters are chosen in a (partially) random manner, and contestants have 30 seconds to create the longest word they can from these 9 letters that is in the dictionary. Dan and Diarmuid will present their own approaches to modelling this game in Excel – starting with a text file of the complete list of Collins Scrabble Words (2019), each has built a spreadsheet that takes a 9 letter input and outputs the longest possible words that can be made from the inputs. Dan and Diarmuid will each use different Excel modelling techniques and explain their thought processes behind how they approached the modelling problem.