TitGer: an electronic worksheet for simulating the titration of a mixture of polyprotic species

[摘要] The aim of this paper is to present a simple way of treating the general equation for acid-base titrations based on the concept of degree of dissociation, and to propose a new spreadsheet approach for simulating the titration of mixtures of polyprotic compounds.The general expression, without any approximation, is calculated a simple iteration method, making number manipulation easy and painless.The user-friendly spreadsheet was developed by using MS-Excel and Visual-Basic-for-Excel. Several graphs are drawn for helping visualizing the titration behavior. A Monte Carlo function for error simulation was also implemented. Two examples for titration of alkalinity and McIlvaine buffer are presented.

[学科分类] 化学（综合）

[关键词] titration simulation;mixture of polyprotic species;acid-base titration.