While I appreciate the effort you put into developing your program, and I applaud the rationale behind it, I think you're giving yourself way too much credit for your accomplishment. The fact of the matter is that an amphibole nomenclature routine (or for that matter, a nomenclature routine for any mineral group) can be easily put together in Excel without the need for VBA programming, simply by using the formulas already available in Excel. Indeed, one of the assignments I've given to my mineralogy students (both graduate and undergraduate) is to derive an Excel-based spreadsheet which normalizes EPMA amphibole analyses, and I give further "brownie points" if they include a nomenclature routine.

Amphibole nomenclature is based on simple chemical rules, outlined in Leake et al. 1997 and Leake et al. 2004. For example, if an amphibole has Ca >= 1.5 apfu in the M4 site, Na+K >= 0.5 apfu in the A site, Ti < 0.5 apfu, Si > 6.5 apfu in the T site, and Mg/(Mg+Fe2) > 0.5, then the mineral is edenite. In this example, 5 chemical parameters define edenite, and these 5 parameters can be easily incorporated into a set of nested IF statements in Excel. In older versions of Excel (which I still use), one is limited to no more than 7 nested IF statements. So, to name all the amphiboles takes me 25 columns of nested IF formulas, and that number of columns seems somewhat high because most of my columns contain considerably less than 7 nested IF statements, just to limit the complexity of any individual formula and keep things organized and attractive. Newer versions of Excel dispense with the nesting limitation, and thus the formulas could be reduced to very few columns (albeit individually more complex).

Not only do I name the basic amphiboles, but I also include extra columns which test for the presence of minor elements in sufficient quantity to be included as obligatory modifiers (i.e. if K > 0.5 in the previous edenite example, the name would be potassic-edenite). Similarly, I include columns for the optional chemical modifier, so for example I might end up with a name such as chlorian potassic-edenite.

Contrary to your assertion that such formulas would require a whole sheet per analysis, my all takes place on one line. So it is easy to input an amphibole chemical analysis on the left-hand side of the spreadsheet, copy the formulas down from the preceding line, and instantaneously name dozens or hundreds of entries. My spreadsheet not only allows for an assigned (or floating) Fe3/∑Fe ratio, but also for an assigned (or floating) Mn3/∑Mn ratio, to permit normalization and naming of amphiboles such as kornite and ungarettiite (with an optional input for Li estimate for the former). The amphibole normalization section allows for 6 different "normal" cation-based routines, 2 different routines optimized for Mn3-bearing amphiboles, and the traditional 23 O routine. If one routine doesn't work well, simply changing a few cells makes another routine available.

In addition to amphibole, I've set up comparable sheets for pyroxenes, the eudialyte group, micas, tourmalines (the most difficult one), the osumilite group, the epidote group, and several other complex mineral groups. Each spreadsheet took me about a day to put together, with the original amphibole one taking the longest and the other ones loosely modeled after it.

All in all, it's a great exercise to have complete control over how minerals are normalized and named. There are no "black box" formulas someone else wrote to rely on. And because it's written using the standard Excel formulas, it works in all versions of the program, across all computer platforms, Mac & PC included. To be clear, it's not my intention here to offer a nomenclature program to compete with yours. My point is simply that while a program such as yours certainly has its value, I would personally recommend to anyone interested in normalizing chemical data and naming minerals to simply sit down with Excel, with the appropriate issue of Canadian Mineralogist or European Journal of Mineralogy (these two journals seem to have the most collected nomenclature papers), and a free afternoon, and just build a spreadsheet to suit your own needs.