Open Thread: How are you using Excel?

Yesterday, I mentioned I’d been talking with someone who’s looking at interesting things people are doing with Microsoft Excel. I talked to her again yesterday, and with her official okey-dokey, I’ll virtually introduce Tralee Pearce (*waves*), a reporter from Toronto’s Globe & Mail whom you might remember from a very swell article about the Hipster PDA.

So, by request – and to help Tralee with fleshing out her fun-sounding article – I hope you all will jump in here: What kind of cool, novel, and non-obvious stuff are you doing with Excel? What’s the wildest, most obsessive, most nerdy thing you ever saw someone do with our favorite spreadsheet program?

I implemented 56 bit DES...

I implemented 56 bit DES encryption in excel once. I was trying to get a better feel for how the algorithms worked, but I didn’t want to use a formal language. Excel worked, however doing transpositions, and converting to and from binary with 16 bit numbers required some manuevering. The best part though is that it was all vanilla Excel. No VB script or macros required.