Microsoft Excelのテーブル機能を利用した酸塩基滴定曲線シミュレーション

  • 吉村 季織
    国立大学法人東京農工大学大学院生物システム応用科学教育部

書誌事項

タイトル別名
  • Simulation of Acid-Base Titration Curve by Using Table-Function in Microsoft Excel
  • Microsoft Excel ノ テーブル キノウ オ リヨウ シタ サンエンキ テキテイ キョクセン シミュレーション

この論文をさがす

抄録

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.

収録刊行物

被引用文献 (4)*注記

もっと見る

参考文献 (9)*注記

もっと見る

詳細情報 詳細情報について

問題の指摘

ページトップへ