EXCEL模拟计算三元部分互溶体系多级萃取过程实例  

Computation Process of Multi-stage Extraction of Liquid Partial Soluble System by Using EXCEL

作　　者：孔令涛 马凤云[1] 刘景梅[1] 

机构地区：[1]新疆大学化学化工学院煤炭清洁转化与化工过程新疆维吾尔自治区重点实验室,新疆乌鲁木齐830046

出　　处：《广东化工》2018年第1期242-244,240,共4页Guangdong Chemical Industry

基　　金：新疆自治区特色品牌专业(新高教[2016])

摘　　要：以间苯二酚(A)-水(B)-正丁醇(S)部分互溶体系为例,利用EXCEL计算环境,通过其自带的"IF条件判断"、"单变量求解"和MINVERSE及MMULT函数功能,实现了多级逆流和错流萃取理论级数的自动试差计算,并通过各级萃取率及总萃取率的求取,分析了两种萃取工艺的优劣。与图解法相比,采用EXCEL可方便快捷准确地完成试差过程,无需编程,因而可以解决老师讲述试差过程耗时较长等问题,有利于课堂中的教与学。With resorcinol（B）-water（A）-n-butylalcohol（S） system as an example, the computation process with trial and error method was achieved automatically by EXCEL involving these functions including ＂IF＂, ＂Goal Seek＂, ＂＇MINVERSE＇＂ and ＂MMULT＂. Then, the process features of multi-stage counter current and cross-flow extraction have been discussed by the calculation of extraction rates. Compared with the graphic method, the calculation by EXCEL without programming can accomplish test process accurately and promptly which could shorten the teaching time and be beneficial to teaching and learning in a classroom.

关 键 词：多级萃取 部分互溶体系 试差法 EXCEL 

分 类 号：TQ028.32[化学工程]