【摘要】 针对复杂酸碱互滴体系中pH的计算和滴定曲线的绘制，推导滴定过程中任意时刻pH计算的高次方程运算通式；然后利用Excel软件的“单变量求解”结合“宏”“规划求解”等命令发展了适用于多种酸碱滴定体系曲线绘制的一般方法；在此基础上，通过VBA代码将计算方法封装为一个界面友好的工具TitraChart;教学实践显示，该工具容易掌握、耗时短，计算准确度高，是酸碱滴定分析理论教学及实验研究的好帮手。更多还原

【Abstract】 For the calculation of pH and the plotting of titration curves in complex acid-base titration systems, a general formula for high-order equation calculation of pH at any time during the titration was derived.Based on the equation, a combination of“goal seek”,“macro”and“solver”commands in Excel software was employed to develop a general approach for plotting curves of various acid-base titration system.Moreover, the approach was encapsulated into a user-friendly tool TitraChart through VBA code, with which the teaching practice shows that this tool is easy to master, time-efficient, and highly accurate in calculation, making it an excellent assistant for theoretical teaching and experimental research of acid-base titration analysis.更多还原