 |
| The competitors take the stage in Las Vegas (WSJ) |
the omnipresent office spreadsheet software has spawned ranks of data geeks who see Excel as a sport. And here they were at the biggest table of them all: the Microsoft Excel World Championship, held at the HyperX Arena Las Vegas in the Luxor Hotel & Casino. (One floor down from a show by the comedian Carrot Top.)Those who, er, excel at competitive Excel are able to identify classes of problems quickly (financial, statistical, dataset searching, etc.), select the functions (built-in algorithms like IRR and COVAR) that might be useful, and put together lines of calculation that produce the answers.
...the thrills were off the charts at the main tournament, where rivals battled for the Excel championship over three 30-minute sessions that included both high drama and hexadecimals. Watching the action unfold on a giant screen, the live audience screamed cheers of encouragement and surprise and marveled at the rich data types, tables, monster functions, and the dreaded #ref error flashing before them.
The above approach to spreadsheet building is frankly, anathema to accountants and many financial analysts. In real-world finance we have to build auditable spreadsheets that are reviewable by others. This means organizing linked spreadsheets so that one has the data inputs, others the calculations, and still others the reports. It also helps to write "notes" about what is going on in particular cells.
In Excel tournaments, where the object is to solve the problem in 30 minutes and there is no need, say, to have a work colleague run the calculations in the modeler's absence, many of these design techniques can be ignored.
That said, there is always a need for genius programmers that can get Excel to solve problems that seemed beyond the software's capabiities. At these tournaments it's nice they're finally getting some recognition.
No comments:
Post a Comment