TCE ForumWhats NewSearchOrders

The Chemical Educator

ISSN: 1430-4171 (electronic version)

Table of Contents

Abstract Volume 8 Issue 5 (2003) pp 298-302

Solving pH Problems on a Spreadsheet

Robert de Levie,* Guido Frison, and Alberto Calatroni

Chemistry Department, Bowdoin College, Brunswick, ME, 04011, USA,; European School of Varese, Varese, Italy; and Politecnico of Milan, Milan, Italy
Received May 28, 2003. Accepted July 3, 2003.

Published online: 21 August 2003

Abstract. Starting from the general expression HC = 0 for any mixture of acids, bases, and salts we find the pH as the root of this expression either by bisection or by using the Newton-Raphson or Levenberg-Marquardt algorithms. All three are readily implemented on a spreadsheet.

Key Words:  In the Classroom; analytical chemistry; titration theory

(*) Corresponding author. (E-mail:

Article in PDF format (230 KB) HTML format

Supporting Materials:


Issue date: October 1, 2003

The Chemical Educator 1996-2017