Public Files

From my days as an Excel guru

emailcrypt.xls

A tool that generates Javascript to encrypt and transform your email address into "code," making it harder for spam harvesters to crawl and add your email to their list.

minmaxif.xls

Like sumif(), countif() for the min() and max() functions

medianif.xls

Like sumif(), countif() for the median() functions

quartif.xls

Like sumif(), countif() for finding quartiles

georeturn.xls

A geometric return function

clock2.xls

An Excel graphical animated clock

clock_timer.xls

Like Clock2 above, but as a count-down timer

wacc.xls

Calculate WACC (Weighted Average Cost of Capital)

bondbuilder4.xls

Bond calculations

randomiser.xls

Randomly select Y items out of a list of X (e.g. select winners in a competition)

dispatch.xls

Shows an interesting use of graphics in Excel - you usually don't think of using the cells as pixels

79xxdirectory.xls

Creates XML directory files for Cisco 79xx series phones (e.g. 7940)

© 1987-2024