A novel multipurpose Excel tool for equilibrium speciation based on Newton-Raphson method and on a hybrid genetic algorithm.

A new algorithm for simulation of chemical equilibria is developed, based on classical Newton-Raphson method applied to mass balance. This tool, named EST (Equilibrium Speciation Tool), is improved by using a robust Genetic Algorithm. In addition, EST works by using Excel spreadsheets and therefore offers the innovation of a great simplicity and versatility. In fact, it allows the users to simulate, or to obtain from experimental data, desired chemical-physical parameters as well as to interact with other available or freely created Excel tools. The reliability of this utility is here proved by comparison with some published data by other authors, concerning both complicated homogeneous and heterogeneous equilibria. In addiction its flexibility is tested computing thermodynamic parameters by using experimental calorimetric data referred to the complex formation of cobalt(II) with a macrocyclic ligand. A brief review and comparison of the relative robustness and quickness of main numerical methods are also reported.