A pH Calculator, a Virtual Titrator, a Real Titration Data Analyzer, a Distribution Diagram Generator - that's CurTiPot, the all-in-one freeware to learn, teach and work with chemical equilibrium of acids, bases, salts and buffers at home, classroom, interactive 'dry-lab' or research laboratory. Features of this powerful suite of MS Excel spreadsheets embrace:
- pH calculation of any aqueous solution of strong and weak acids, bases, salts, buffers and mixtures of up to 7 polyprotic systems (>40 species), with activity coefficient estimation;
- Simulation and overlay of acid-base titration curves of any complexity, with or without random errors in pH and/or volume. Valuable for teaching, generation of unlimited titration exercises and evaluation of the feasibility and accuracy of new titrations.
- Analysis of pH vs. volume data from simulated and real potentiometric titration curves by two methods: i) graphical representation of curves, assisted by cubic splines interpolation and smoothing of derivative curves, for accurate evaluation of inflections (end-points); ii) determination of concentrations and refinement of pKa values by multiple nonlinear regression (based on the Solver supplement of Excel), essential for difficult titrations with undefined inflections, e.g., acid rain.
- Generation of protonation curves and distribution diagrams of equilibrium species of acids and bases at equilibrium as a function of pH or of added volume of titrant.
- Expandable database with pKa values of 250 acids and bases.
Simply unzip the single curtipot_.xls file, open it with Microsoft Excel (at medium security level), activate macros and start learning, working and teaching. No install/uninstall required, all macros are removed when closing file. The software is completely free for educational and non-commercial use.