Random Buffy the Vampire Slayer Episode Generator

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:

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.


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

Leave a Reply