ChemicalFormulas Add-In for Excel Files

------------------------------------------------------------------------------
ChemicalFormulas Add-In for Excel v1.1
------------------------------------------------------------------------------

Copyright 2009 Axel Mueller (molshape@users.sourceforge.net)

This program is free software; you can redistribute it and/or modify it under
the terms of the GNU General Public License as published by the Free Software
Foundation; either version 3 of the License, or any later version.

This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

------------------------------------------------------------------------------

Compatibility of ChemicalFormulas Add-In for Excel v1.1 has been testet for
Microsoft Excel 2007, 2010, and 2013.

Please refer to the Microsoft Office Support page at

https://support.office.com/en-us/article/add-or-remove-add-ins-in-excel-0af570c4-5cf3-4fa9-9b88-403625a0b460

for a detailed discription on how to add or remove Add-Ins in various Excel
versions.

------------------------------------------------------------------------------

SHORT MANUAL

ChemicalFormulas adds four new Excel spreadsheet functions. The following
syntax is used (a parameter within squared brackets is optional; its default
value is given as well):


  ExpandAliases(Formula)

      Commonly used chemical abbreviations in a text formula are substituted
      by their corresponding chemical formula. (Note: In order to avoid
      ambiguities with the element Actinium, the abbreviation AC is used for
      an acetyl group instead of Ac.)

      Examples:
          =ExpandAliases("PhO(CH2)2CH3")        gives   (C6H5)O(CH2)2CH3
          =ExpandAliases("Et2O")                gives   (C2H5)2O


  ContractFormula(Formula [; abbreviated = TRUE])

      A text formula is converted to a molecular or empirical formula,
      respectively. The optional, boolean parameter "abbreviated" specifies
      whether to use the index number "1" or not.

      Examples:
          =ContractFormula("PhO(CH2)2CH3")      gives   C9H12O
          =ContractFormula("H2O"; FALSE)        gives   H2O1


  HillFormula(Formula [; abbreviated = TRUE])

      A text formula is converted to a molecular or empirical formula,
      respectively, and the atoms present are sorted in Hill order. The
      optional parameter "abbreviated" is used as specified in ContractFormula.

      Examples:
          =HillFormula("HOOC(CHOH)2COOK")       gives   C4H5KO6
          =HillFormula("HCl"; FALSE)            gives   H1Cl1


  MolarMass(Formula)

      The molar mass of a given text formula is calculated by this function
      in grams per mole.

      Examples:
          =MolarMass("PhO(CH2)2CH3")            gives   136.190979
          =MolarMass("Na2SO4")                  gives   142.0421448


  The formula output "#BRACKETS?" is caused by inconsistent parentheses.

      Example:
          =ContractFormula("CH3(COOH")          gives   #BRACKETS?


  Other erroneous inputs are largely ignored, they can, however, produce
  wrong results.

      Examples:
          =ExpandAliases("CH_3COOh")            gives   CH_3COOh
          =ContractFormula("CH_3COOh")          gives   C2HOOh
          =HillFormula("CH_3COOh")              gives   C2HO
          =MolarMass("CH_3COOh")                gives   #VALUE!

------------------------------------------------------------------------------