Unusual Uses of Excel
In the Excel All-Star Battle, eight stars from the world of competitive Excel will compete to solve an Excel case. The top four finishers will advance to round 2, with the final 2 competing to solve the third case. This event is organized by Andrew Grigolyunovich and his team from the Financial Modeling World Cup (FMWC). While the All-Star Battle has some fun with the Excel cases, the finals of the FMWC in 2021 were featured on ESPN3, sponsored by Microsoft, and included $30,000 in prize money.
During the All-Star Battle, the color commentary will be provided by two Excel MVPs. You might know Oz du Soleil from his Excel On Fire YouTube channel or Bill Jelen from MrExcel.com.
Watching 8 people compete in Excel on TV might seem unusual, but the world is filled with examples of unusual uses of Excel. If you spend 40 hours a week using Excel at work, it likely will be your favorite tool to track details of your life. In a recent survey about home uses for Excel, people are tracking all sorts of things.
But then there are people who go beyond tracking a few tables in Excel. In this article, let’s take a look at ten amazing Excel spreadsheets.
I’ve met many people who use Excel as a drawing canvas. Once you change the column width to have the same number of pixels as the row height, you have a very large sheet of graph paper.
You can then use borders or fill color to make a rendering. Here is a complete landscape design that was done by using Excel as grid paper:
One very awesome and current use of Excel is the supporters of the Newcastle United Football Club of the English Premier League. The Wor Flags fan group is using a seat map in Excel of the 50K+ seats at their St. James’ Park stadium to plan out massive displays during the soccer match.
Here is a photo of a display from the final match of the 2021-2022 season. Note the white, black, and yellow “UNITED” on the far sidelines and the blue star on a white background in the Leazes’ End. Photo courtesy of Chris Heron of the Wor Flags group.
Planning of these stadium displays is all done in Excel. Wor Flags member Chris Heron explains how Excel is used. Consider the blue star at the end of the stadium. In a worksheet for this end of the stadium, 9,420 cells – from A1 to FA40 are used to show the seats and aisles. Since no one is sitting in the aisles, the art team has to be careful to not have letters span an aisle. Heron explains, “Essentially, each cell is like a pixel in the stadium.”
Compare the blue star in the image above with the Excel spreadsheet in the image below. Chris uses =(COUNTIF(B1:FA60,”B”)*1.1) to count how many of each color of foil is needed for the display including 10% extra.
Heron notes that his day job is as a project manager for a Building Controls company. At work, he uses Excel “for just the usual things like work rotas, setting sheets, site reports & price lists.”
“I just thought we needed a system that could be used for designing these styles of displays and give those putting out foils/flags a map to show which colors go where. I thought of Excel because you can number each cell to show a location, and color each cell to establish designs. I left blank cells to show walkways and exits, as it gives a good idea if a letter will look good, or if it’ll be broken up too much to be visible.
Once everything is mapped out in Excel, the workbook is shared via a group of volunteers using WhatsApp. These volunteers then meticulously attach the colored foils to each seat in the stadium. The results are amazing.
Leave a comment below if you’ve used Excel to solve unusual problems.