TitGer: uma planilha eletrônica para simulação de titulação de mistura de compostos polipróticos TitGer: an electronic worksheet for simulating the titration of a mixture of polyprotic species

• Main Authors: André Fernando Oliveira, Astréa F. de Souza Silva, Mário A. Tenan, Sérgio Lineu Olivo
• Format: Article
• Language: English
• Published: Sociedade Brasileira de Química 2007-02-01
• Series: Química Nova
• Subjects: titration simulation; mixture of polyprotic species; acid-base titration
• Online Access: http://www.scielo.br/scielo.php?script=sci_arttext&pid=S0100-40422007000100036

<abstract language="eng">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.