TitGer: uma planilha eletrônica para simulação de titulação de mistura de compostos polipróticos

Química Nova

André Fernando Oliveira¹  Astréa F. De Souza Silva¹  Mário A. Tenan¹  Sérgio Lineu Olivo¹ 

[1] ,Universidade de Mogi das Cruzes Núcleo de Ciências Ambientais Mogi das Cruzes SP ,Brasil

关键词: titration simulation;    mixture of polyprotic species;    acid-base titration;   

DOI  :  10.1590/S0100-40422007000100036

来源: SciELO

【 摘 要 】

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.

【 授权许可】

CC BY-NC   
 All the contents of this journal, except where otherwise noted, is licensed under a Creative Commons Attribution License