There are a few specialized Microsoft Excel spread sheets that may have some public interest. Some of them are specific answers to questions that came up on one of the Excel mailing lists.
The links are:
-
Cubic Recursion
This is an Excel workbook that solves cubic equations using a recursive technique with no VBA. I don't know what makes it work but I'd like to know. Please have a look.
-
Fitting data
Someone asked for this long ago.
-
GausHaus
GausHaus_Excel4
An implementation of the old FORTRAN program that fits Gaussians to data with peaks.
-
TangentPlane
Someone was interested in graphing the location of sales offices with respect to a home office. The vector arithmetic was interesting to me and this is the result.
-
US Income Tax
About 2000 the US IRS started making Adobe PDF fill-out forms available. This workbook is a sanitized version of the code that I used to prepare Adobe FDF files that can be imported directly into downloaded USIRS forms. It requires extensive changes for each new year and there might be a newer version available if there is interest.
-
Utility
I have set up Excel so that it always keeps this workbook in the background. There are several VBA functions in it that I like.
Doug McNutt dmcnutt@macnauchtan.com,
Thu Feb 22 15:53:13 MST 2007