Excel Movies and Monitors

Congratulations to Alex Kerin, whose name I selected in the random draw for the Excelerator Quiz giveaway. Here’s his name at the top of the list, after I used the RAND function, and sorted the Rand column in ascending order.
Alex’s prize is a 23″ monitor, plus a keyboard and mouse, courtesy of the PowerPivot team. Thanks to everyone who participated, and to the PowerPivot team, and Megan at Ignite Social Media, who organized the giveaway.

The Excel Movie Database

The Oscar nominations will be announced next Tuesday, February 2nd (oh, Groundhog Day, that was a good movie). In honour of the occasion, I’ve updated my Excel Movie Database sample file.
I included some movies from the Top 250 Movies list at the IMDb website. You can add movies from your DVD collection, or your Netflix list.
Then use the selection boxes to see movies from a specific category, and/or featuring your favourite actor. In the previous version, you could only choose Category OR Actor, and now you can choose one or both. (Exciting, I know!) Or, clear both criteria cells, to see all the movies.

Download the Sample File

You can download the Excel movies database file from the Contextures website. It’s in Excel 2003 format, and zipped. The file contains macros, so you’ll have to enable those to make the file work.

The Perfect Computer

I couldn’t find any movies about Excel, to add to the Excel movies database, but computers play a leading role in several movies. You might remember HAL 9000, from “2001: A Space Odyssey”.
HAL: Let me put it this way, Mr. Amor. The 9000 series is the most reliable computer ever made. No 9000 computer has ever made a mistake or distorted information. We are all, by any practical definition of the words, foolproof and incapable of error.
Yes, that was the dream, way back in 1968, when they made “2001: A Space Odyssey”. Over 40 years later, we haven’t even come close to achieving that goal! Well, maybe it’s not the computers’ fault – the users might be part of the problem.