CAJ | 학술논문

对于恒回流比操作方式的间歇精馏,过程计算量大且公式应用相对复杂,用计算机完成间歇精馏的过程计算及操作仿真已经成为许多国内外学者的研究课题.为了满足系统的响应速度,提高动态釜液量误差,用Excel的VBA、函数、图表及重算等功能,实现间歇精馏的计算机仿真的新方法.在Excel中,建立了间歇精馏过程的数学模型与"数据处理表",完成多项式拟合,由递推公式确定塔内各塔板液相组成x_n与时间t的动态响应关系.获得的六次拟合曲线接近于实测的平衡数据,其相关系数达到0.999,各塔板液相组成x_n与时间t的动态响应关系与实际计算吻合较好,获得了较满意的结果,为设计提供有效依据.
대우항회류비조작방식적간헐정류,과정계산량대차공식응용상대복잡,용계산궤완성간헐정류적과정계산급조작방진이경성위허다국내외학자적연구과제.위료만족계통적향응속도,제고동태부액량오차,용Excel적VBA、함수、도표급중산등공능,실현간헐정류적계산궤방진적신방법.재Excel중,건립료간헐정류과정적수학모형여"수거처리표",완성다항식의합,유체추공식학정탑내각탑판액상조성x_n여시간t적동태향응관계.획득적륙차의합곡선접근우실측적평형수거,기상관계수체도0.999,각탑판액상조성x_n여시간t적동태향응관계여실제계산문합교호,획득료교만의적결과,위설계제공유효의거.
For the batch distillation of operation with a constant reflux ratio,the calculation process is time-consuming and application of the formula is rather complicated.Using computer to complete the calculation of batch distillation has been an universal study for mostly internal and overseas scholars.The new methods implement the computer simulation of the batch distillation,which includes the uses of the functions of Excel VBA,function and diagram,etc.In the Excel,mathematical models for the process of batch distillation and table of data processing are established to fit the given data using by polynomial.Recursion formula establishes the dynamic response relationship between the liquid phase x_n and time t of each plate in distillation column.The fitting curve is close to real balance data,and its correlation coefficient reaches 0.999.The response relationship between the liquid phase x_n and time t of each plate in distillation column is in accord with its actual computation.The method of mixed Programming using by Excel and VBA is simple and practical,it can replace simulation program which use difficult and complex programming software to implement the process computation and computer simulation.This method has a better satisfied result.