Application of Linear Programming Method by Microsoft Excel Solver to Titration Curve Analysis

Norio YOSHIMURAa*, Masanori OKAZAKIa and Naoya NAKAGAWAb

aGraduate School of Bio-Applications and Systems Engineering, Tokyo University of Agriculture and Technology
2-24-16 Nakacho Koganei, Tokyo 184-8588, Japan
bThe University of Electro-Communications
1-5-1Chofugaoka, Chofu, Tokyo 182-8585, Japan

(Received: January 6, 2003; Accepted for publication: February 17, 2003; Published on Web: April 22, 2003)

Using Microsoft Excel solver, which is an add-in program to solve optimization problems, a pK distribution was estimated. The pK distribution shows the relation between the pK values and concentrations of acids in a sample solution and is applied to analyze a heterogeneous surface. A titration curve was obtained from titration of a citric acid solution with a sodium hydroxide solution. The theoretical equation of the titration curve was converted into a linear equation. The equation was fitted to experimental data by the linear programming method included in Excel solver. The pK distributions estimated by Excel solver and by a specially designed program applying the simplex method are almost equal. This indicates that Excel solver can not only be applied for excellent estimation of pK distribution, but also that all Excel users can easily carry out similar determinations.

Keywords: Excel solver, Linear programming method, Titration curve, pK distribution

Abstract in Japanese

Text in Japanese

PDF file(300kB)