A Direct Approach for Solving Simultaneous Equations-Combining a Basic Understanding of Equilibria with the Convenience and Power of a Spreadsheet

Abstract

145. Descriptions of an "easy-to-use iterative" method to reinforce concepts in equilibrium that use spreadsheets. Article includes examples of data, advantages and limitations of the method, and suggests sample problems for use with this method.

Spreadsheet and Computing Language for a Chemical Application

“…Using a spreadsheet in chemistry is important; indeed, numerous papers were published between 1987 and 1995. Spreadsheet applications have different topics: quantum mechanics, 4,5 kinetics, [6][7][8][9][10][11] electrochemistry, [12][13][14][15][16][17] thermodynamics, 18 and laboratory operations. [19][20][21] One of our goals is to show that programming or using a spreadsheet can be a tool in understanding chemistry.…”

“…Using a spreadsheet in chemistry is important; indeed, numerous papers were published between 1987 and 1995. Spreadsheet applications have different topics: quantum mechanics, , kinetics, − electrochemistry, − thermodynamics, and laboratory operations. − …”

Using Least Squares To Solve Systems of Equations

“…Methods for numerical solution of systems of equations include one-step procedures like matrix inversion for linear systems, and iterative methods, like Newton–Raphson, successive approximation, and bisection for nonlinear systems . Most of these have been discussed in this Journal , − and have been implemented with pocket calculator strategies , and spreadsheets, especially Microsoft Excel. ,,, The successive approximation methods work best when reduced to a single equation in one unknown, as they are sensitive to initial guesses for multiple variables and equations. The spreadsheet approaches mostly employ Excel’s Solver routine and are not so limited; however, the methods for coupled equilibria have emphasized ways to reduce the number of equations to be solved.…”