Simulation of Acid-Base Titration Curve by Using Table-Function in Microsoft Excel


Graduate School of Bio-Applications and Systems Engineering, Tokyo University of Agriculture and Technology,
2-24-16 Nakacho Koganei, Tokyo 184-8588, Japan

(Received: July 28, 2005; Accepted for publication: October 24, 2005; Published on Web: February 28, 2006)

A simulation method for acid - base titration was developed by using not VBA programming but fundamental functions of Microsoft Excel. For calculating a pH value corresponding to a given titration volume, an approximation is need. In this study, the approximation was computed on a worksheet of Excel. Moreover, for simulating a titration curve, the pH value must be calculated for every dropping of titrant. The simulations were performed by using "table" which is one of the fundamental functions of Excel.
Using this method, not only weak acid (base) - strong base (acid) titrations such as citric acid - sodium hydroxide and ammonium hydroxide - hydrochloric acid, but also weak acid - weak base titrations such as citric acid - ammonium hydroxide were simulated. The effect of errors, which arise from carbonic acid contamination and the round-off operations of titration volumes and pH values, on titration curves were discussed.

Keywords: Excel, Table, Titration curve, Simulation, Bisection method

Abstract in Japanese

Text in Japanese

PDF file(486kB)