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

Abstract

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.

Keywords

• titration simulation
• mixture of polyprotic species
• acid-base titration