Solving pH Problems on a Spreadsheet

TCE

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, rdelevie@bowdoin.edu; 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: rdelevie@bowdoin.edu)

Article in PDF format (230 KB) HTML format

Supporting Materials: