(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
Text in Japanese