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

DOI Web Site Web Site 4 Citations 9 References
  • YOSHIMURA Norio
    Graduate School of Bio-Applications and Systems Engineering, Tokyo University of Agriculture and Technology,

Bibliographic Information

Other Title
  • Microsoft Excelのテーブル機能を利用した酸塩基滴定曲線シミュレーション
  • Microsoft Excel ノ テーブル キノウ オ リヨウ シタ サンエンキ テキテイ キョクセン シミュレーション

Search this article

Abstract

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.<BR>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.

Journal

Citations (4)*help

See more

References(9)*help

See more

Keywords

Details 詳細情報について

Report a problem

Back to top