Over the years, and out of necessity, I have become a bit of an Excel jockey. This page is a repository of a few spreadsheets and macros I've written that may be of general interest.

A tool that generates Javascript to encrypt and transform your email address into "code," making it virtually impossible for spam harvesters to crawl and add your email to their list. For example, and notice that the e-mail address and subject do not appear anywhere in the HTML source.
Like sumif(), countif() for the min() and max() functions
Like sumif(), countif() for the median() function
Like sumif(), countif() for finding quartiles
A geometric return function
An Excel graphical clock
Same as Clock2 but a count-down timer
Calculate WACC (Weighted Average Cost of Capital)
Bond calculations
Randomly select Y items out of a list of X (e.g. select winners in a competition)
Shows an interesting use of graphics in Excel
Creates XML directory files for Cisco 7940 series phones
Bookmark and Share