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.


You may also like...

5 Responses

  1. Alex Kerin says:

    Many thanks to you and to the sponsor. I was getting very fed up with my current small monitor – the new one will greatly enhance my productivity, I’m sure, while the old one will be part of my 5 year old’s ‘new’ computer.

  2. chip says:

    Back in the Lotus 123 v1A days, there was an add-on called HAL that…well, I can’t recall what it did; it’s been a while. And I never used it, but when it came out I read that if you typed into a cell “Open the pod bay doors, HAL”, it would instead put into the cell “I’m sorry Dave, I’m afraid I can’t do that.” If true, my favorite Easter egg ever.

  3. Alex, you’re welcome! Glad to hear that you needed a big new monitor, so it’s going to a good home. ;-)

    Chip, that would be an awesome Easter egg, so I hope it’s true!

  4. Jon Peltier says:

    Groundhog Day and 2001: A Space Oddysey. Two great movies.

  5. Yeah, I can watch Groundhog Day again and again.

Leave a Reply

Your email address will not be published. Required fields are marked *