萃取计算的Excel VBA图解方法  

Extracted calculation of the Excel VBA diagrammatic method

作　　者：彭小平[1] 颜清[2] 

机构地区：[1]上饶师范学院化学系,江西上饶334001 [2]上饶师范学院数学与计算机系,江西上饶334001

出　　处：《计算机与应用化学》2008年第11期1412-1416,共5页Computers and Applied Chemistry

基　　金：江西省教育厅2008年度科技资助项目(GJJ08461).

摘　　要：利用Microsoft Excel的自定义函数与VBA混合编程准确而又快捷地解决了单级萃取和多级萃取的诸多计算问题,所获得的数据结合Excel的图表功能再现手工绘图原理,从而形成了萃取过程的Excel VBA图解计算方法,实现了萃取计算的图形化、可视化和自动化。Excel VBA图解计算方法易于掌握,避免了传统的手工计算及绘图带来的较大误差,对于处理类似的化工计算有一定的参考作用。Using the customized function of Microsoft Excel and VBA programming, can solve many calculation problems of singlestage extraction and multi-stage extraction accurately and facilely represents the process of manual drawing by the function of Excel chart. Thereby, formed the Excel VBA diagrammatic calculation method of extraction process and achieves the graphical, visualization and automation of extraction calculation. The Excel VBA patterned calculation is easy to master, and consequently avoided the mistake of traditional manual calculation and drawing. This method is very straightforward and it is also useful to the similar chemical calculation.

关 键 词：EXCEL VBA 萃取计算 图解方法 

分 类 号：G434[文化科学—教育学]