Random Buffy the Vampire Slayer Episode Generator

Let me first say that I'm a fan of everything Joss Whedon.  (EDIT: OOF, sorry somethings just don't age well. It's really tough to be a fan of something and later find out that that author/producer/artist/actor is a bad person. I have fond memories of watching Buffy, Angel, Dollhouse, and a few other things made by that person. But I won't continue supporting a bad person who has done bad things.)

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:

BuffyGeneratorScreenShotAll you have to do is hit 'F9' (windows) or 'Command + =' (mac) and it will pick a random episode, and tell you which season, disk and episode number to find it.  I've attached it here.

BuffyEpisodeGenerator

This entry was posted in excel, Visualization and tagged . Bookmark the permalink.

Leave a Reply

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