Chemical Equilibrium by Gibbs Energy Minimization on Spreadsheets

This paper describes the use of Solver function, contained in the Microsoft Excel spreadsheetpackage, in computing the chemical equilibrium of known substances in either an ideal or non-idealgas phase by the method of direct Gibbs energy minimization. Apart from some deficiency of Solverin applying the generalized reduced gradient method for this type of problem, the approach is simpleto understand and apply and provides a direct solution procedure whereas the traditional approachoften employs a high-level programming language. The results are compared with those obtained bya Fortran program, and found to be in satisfactory agreement.