酸碱平衡体系基于Excel的直观计算  

Intuitive calculations of acid-base balance system based on Excel

作　　者：王业根[1] 

机构地区：[1]盐城卫生职业技术学院,江苏盐城224005

出　　处：《中国医药科学》2012年第17期152-153,162,共3页China Medicine And Pharmacy

摘　　要：基于Excel工作表与宏,建立包含公式的酸碱平衡体系模板,计算滴定过程中的酸度变化,绘制滴定曲线,判断滴定突跃,整个过程简便直观。该方法可修改参数,求解未知量(如酸度、物料浓度与体积、酸常数、缓冲容量等),同时由于没有计算公式的简化,计算结果更为准确。Excel-based worksheets and macros, the establishment of acid-base equilibrium system of templates that contains the formulas, calculate acidity changes during titration, titration curve drawn to determine the break, the entire process simple and intuitive. You can modify the parameters to solve the unknown quantity （such as pH, concentration and volume of material, acid constant, buffering capacity, and so on）. Since there is no formula for simplified, calculation was more accurate.

关 键 词：酸碱平衡 酸度计算 EXCEL 宏 

分 类 号：R446.11[医药卫生—诊断学]