Sunday, October 09, 2022

Competitive spreadsheeting

 Did you know there's such a thing as the Microsoft Excel World Championship? I only found out that it exists just recently, but it's been going for a few years now, as an offshoot of the Financial Modelling World Cup (which I also didn't know existed). Someone should tell me things like this! You know I'm downright weird about playing with Excel spreadsheets for all kinds of unlikely purposes!

Anyway, last night was the qualifying round for this year's competition, and it was brilliant. I think they're probably going to make the task free to download at some point in the future (previous ones are already available - check them out!), and I'd hate to spoil it, but it was divided into five tasks, requiring you to create complicated Excel formulas to find the right answers. It's hugely enjoyable, if you're the kind of person who likes that kind of thing.

I did four of the five tasks in the 60 minutes allotted time, realised I wasn't going to have time to do the last, so submitted the file with five minutes or so remaining (time counts as a tiebreaker). Then I went on to have a go at task number five, looked back over the previous ones and realised I'd made a boneheaded mistake in the second and highest-scoring task - rather than copying the answers into the boxes on the front page to get the total of all twenty sub-tasks, I just summed the whole lot I'd worked out on the other tab, including the example (which had an answer of 1). So the answer I cheerfully typed in for the most valuable question on the whole challenge was 8714 instead of the correct 8713.

If I was at work, I'd give myself the sack for that kind of carelessness. As it is, and since I'm unlikely to qualify for the finals unless everyone else in the qualifiers was equally stupid, I see it as a good learning experience, and I'll practice some more for next year's event! And I'll have a lot of fun watching the grand finals over the next couple of months!

No comments: