TitGer: uma planilha eletrnica para simulao de titulao de mistura de compostos poliprticos

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 degreeof 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 easyand painless.The user-friendly spreadsheet was developed by using MS-Excel and Visual-Basic-for-Excel. Several graphs are drawn for helpingvisualizing the titration behavior. A Monte Carlo function for error simulation was also implemented. Two examples for titration ofalkalinity and McIlvaine buffer are presented.Keywords: titration simulation; mixture of polyprotic species; acid-base titration.