Let me first say that I'm a fan of everything Joss Whedon. So when I was asked last year to create a 'Random Episode Generator' for Buffy, I jumped at the chance. I also think this is a great way to illustrate the usefulness of Excel. That's right, I just wrote the terms 'useful' and 'Excel' in the same sentence. I think Excel is vastly underrated in the nerdy-data community and is very helpful. Again, certain things it does very well, and certain (many) things is does horribly.
But this project is perfect because of it's simplicity. Excel can do this in a heartbeat and look halfway decent as well. Here is a screenshot of the spreadsheet: